/*
 Navicat Premium Dump SQL

 Source Server         : 189
 Source Server Type    : MariaDB
 Source Server Version : 110702 (11.7.2-MariaDB-ubu2404)
 Source Host           : 192.168.31.189:3306
 Source Schema         : eladmin

 Target Server Type    : MariaDB
 Target Server Version : 110702 (11.7.2-MariaDB-ubu2404)
 File Encoding         : 65001

 Date: 29/06/2025 16:25:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for code_column_config
-- ----------------------------
DROP TABLE IF EXISTS `code_column_config`;
CREATE TABLE `code_column_config` (
                                      `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                      `table_name` varchar(180) DEFAULT NULL,
                                      `column_name` varchar(255) DEFAULT NULL,
                                      `column_type` varchar(255) DEFAULT NULL,
                                      `dict_name` varchar(255) DEFAULT NULL,
                                      `extra` varchar(255) DEFAULT NULL,
                                      `form_show` bit(1) DEFAULT NULL,
                                      `form_type` varchar(255) DEFAULT NULL,
                                      `key_type` varchar(255) DEFAULT NULL,
                                      `list_show` bit(1) DEFAULT NULL,
                                      `not_null` bit(1) DEFAULT NULL,
                                      `query_type` varchar(255) DEFAULT NULL,
                                      `remark` varchar(255) DEFAULT NULL,
                                      PRIMARY KEY (`column_id`) USING BTREE,
                                      KEY `idx_table_name` (`table_name`)
) ENGINE=InnoDB AUTO_INCREMENT=226 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='代码生成字段信息存储';

-- ----------------------------
-- Records of code_column_config
-- ----------------------------
BEGIN;
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (191, 'train_pilot', 'id', 'bigint', NULL, '', b'0', NULL, 'PRI', b'0', b'0', NULL, 'id');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (192, 'train_pilot', 'name', 'varchar', NULL, '', b'1', 'Input', '', b'1', b'0', 'Like', '姓名');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (193, 'train_pilot', 'gender', 'varchar', 'gendor', '', b'1', 'Radio', '', b'1', b'0', '=', '性别');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (194, 'train_pilot', 'birthdate', 'date', NULL, '', b'1', 'Date', '', b'1', b'0', NULL, '出生日期');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (195, 'train_pilot', 'create_by', 'varchar', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '创建者');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (196, 'train_pilot', 'update_by', 'varchar', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '更新者');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (197, 'train_pilot', 'create_time', 'datetime', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '创建时间');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (198, 'train_pilot', 'update_time', 'datetime', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '更新时间');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (199, 'train', 'id', 'bigint', NULL, '', b'0', NULL, 'PRI', b'0', b'0', NULL, 'ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (200, 'train', 'pilot_id', 'bigint', NULL, '', b'1', 'Select', '', b'1', b'0', NULL, '飞行员ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (201, 'train', 'type_id', 'bigint', NULL, '', b'1', 'Select', '', b'1', b'0', NULL, '机型ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (202, 'train', 'date', 'date', NULL, '', b'1', 'Date', '', b'1', b'0', NULL, '训练日期');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (203, 'train', 'create_by', 'varchar', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '创建者');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (204, 'train', 'update_by', 'varchar', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '更新者');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (205, 'train', 'create_time', 'datetime', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '创建时间');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (206, 'train', 'update_time', 'datetime', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '更新时间');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (207, 'train_plane', 'plane_id', 'bigint', NULL, 'auto_increment', b'0', NULL, 'PRI', b'0', b'0', NULL, 'ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (208, 'train_plane', 'name', 'varchar', NULL, '', b'1', 'Input', '', b'1', b'0', NULL, '机型名称');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (209, 'train_item', 'item_id', 'bigint', NULL, 'auto_increment', b'0', NULL, 'PRI', b'0', b'0', NULL, 'ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (210, 'train_item', 'name', 'varchar', NULL, '', b'1', 'Input', '', b'1', b'1', NULL, '项目名');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (211, 'train_trains_items', 'id', 'bigint', NULL, 'auto_increment', b'1', NULL, 'PRI', b'1', b'0', NULL, 'ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (212, 'train_trains_items', 'train_id', 'bigint', NULL, '', b'1', NULL, '', b'1', b'1', NULL, '训练ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (213, 'train_trains_items', 'item_id', 'bigint', NULL, '', b'1', NULL, '', b'1', b'1', NULL, '训练项目ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (214, 'train_lxjkz', 'id', 'bigint', NULL, '', b'0', NULL, 'PRI', b'0', b'0', NULL, 'ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (215, 'train_lxjkz', 'train_id', 'bigint', NULL, '', b'1', NULL, '', b'1', b'1', NULL, '训练ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (216, 'train_lxjkz', 'train_item_id', 'bigint', NULL, '', b'1', NULL, '', b'1', b'1', NULL, '训练项目ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (217, 'train_lxjkz', 'train_lxjkz_data_id', 'bigint', NULL, '', b'1', NULL, '', b'1', b'1', NULL, '离心机空战动作项目数据ID');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (218, 'train_lxjkz', 'csq_xy', 'int', NULL, '', b'1', 'Input', '', b'1', b'0', '>=', '测试前_血压(mmHg)');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (219, 'train_lxjkz', 'csq_xl', 'int', NULL, '', b'1', NULL, '', b'1', b'0', '>=', '测试前_心率(bpm)');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (220, 'train_lxjkz', 'csh_xy', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '测试后_血压(mmHg)');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (221, 'train_lxjkz', 'csh_xl', 'int', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '测试后_心率(bpm)');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (222, 'train_lxjkz', 'result', 'varchar', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '结论');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (223, 'train_lxjkz', 'create_by', 'varchar', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '记录人');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (224, 'train_lxjkz', 'create_time', 'date', NULL, '', b'0', NULL, '', b'0', b'0', NULL, '创建时间');
INSERT INTO `code_column_config` (`column_id`, `table_name`, `column_name`, `column_type`, `dict_name`, `extra`, `form_show`, `form_type`, `key_type`, `list_show`, `not_null`, `query_type`, `remark`) VALUES (225, 'train_lxjkz', 'date', 'date', NULL, '', b'1', NULL, '', b'1', b'0', NULL, '记录日期');
COMMIT;

-- ----------------------------
-- Table structure for code_gen_config
-- ----------------------------
DROP TABLE IF EXISTS `code_gen_config`;
CREATE TABLE `code_gen_config` (
                                   `config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                   `table_name` varchar(255) DEFAULT NULL COMMENT '表名',
                                   `author` varchar(255) DEFAULT NULL COMMENT '作者',
                                   `cover` bit(1) DEFAULT NULL COMMENT '是否覆盖',
                                   `module_name` varchar(255) DEFAULT NULL COMMENT '模块名称',
                                   `pack` varchar(255) DEFAULT NULL COMMENT '至于哪个包下',
                                   `path` varchar(255) DEFAULT NULL COMMENT '前端代码生成的路径',
                                   `api_path` varchar(255) DEFAULT NULL COMMENT '前端Api文件路径',
                                   `prefix` varchar(255) DEFAULT NULL COMMENT '表前缀',
                                   `api_alias` varchar(255) DEFAULT NULL COMMENT '接口名称',
                                   PRIMARY KEY (`config_id`) USING BTREE,
                                   KEY `idx_table_name` (`table_name`(100))
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='代码生成器配置';

-- ----------------------------
-- Records of code_gen_config
-- ----------------------------
BEGIN;
INSERT INTO `code_gen_config` (`config_id`, `table_name`, `author`, `cover`, `module_name`, `pack`, `path`, `api_path`, `prefix`, `api_alias`) VALUES (7, 'train_pilot', 'huangwencong', b'1', 'eladmin-train', 'me.zhengjie', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/views/train/pilot', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/api', NULL, '疗养员');
INSERT INTO `code_gen_config` (`config_id`, `table_name`, `author`, `cover`, `module_name`, `pack`, `path`, `api_path`, `prefix`, `api_alias`) VALUES (8, 'train_plane', 'huangwencong', b'1', 'eladmin-train', 'me.zhengjie', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/views/train/plane', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/api', NULL, 'plane');
INSERT INTO `code_gen_config` (`config_id`, `table_name`, `author`, `cover`, `module_name`, `pack`, `path`, `api_path`, `prefix`, `api_alias`) VALUES (9, 'train_item', 'huangwencong', b'1', 'eladmin-train', 'me.zhengjie', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/views/train/item', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/api', NULL, 'item');
INSERT INTO `code_gen_config` (`config_id`, `table_name`, `author`, `cover`, `module_name`, `pack`, `path`, `api_path`, `prefix`, `api_alias`) VALUES (10, 'train_lxjkz', 'huangwencong', b'1', 'eladmin-train', 'me.zhengjie', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/views/train/lxjkz', '/Volumes/Workspace/Hwc/Health/eladmin-mp/eladmin-web/src/api', NULL, '离心机空战');
COMMIT;

-- ----------------------------
-- Table structure for mnt_app
-- ----------------------------
DROP TABLE IF EXISTS `mnt_app`;
CREATE TABLE `mnt_app` (
                           `app_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                           `name` varchar(255) DEFAULT NULL COMMENT '应用名称',
                           `upload_path` varchar(255) DEFAULT NULL COMMENT '上传目录',
                           `deploy_path` varchar(255) DEFAULT NULL COMMENT '部署路径',
                           `backup_path` varchar(255) DEFAULT NULL COMMENT '备份路径',
                           `port` int(255) DEFAULT NULL COMMENT '应用端口',
                           `start_script` varchar(4000) DEFAULT NULL COMMENT '启动脚本',
                           `deploy_script` varchar(4000) DEFAULT NULL COMMENT '部署脚本',
                           `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                           `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                           `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                           `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                           PRIMARY KEY (`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='应用管理';

-- ----------------------------
-- Records of mnt_app
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_database
-- ----------------------------
DROP TABLE IF EXISTS `mnt_database`;
CREATE TABLE `mnt_database` (
                                `db_id` varchar(50) NOT NULL COMMENT 'ID',
                                `name` varchar(255) NOT NULL COMMENT '名称',
                                `jdbc_url` varchar(255) NOT NULL COMMENT 'jdbc连接',
                                `user_name` varchar(255) NOT NULL COMMENT '账号',
                                `pwd` varchar(255) NOT NULL COMMENT '密码',
                                `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                                `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                                `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                                `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                PRIMARY KEY (`db_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='数据库管理';

-- ----------------------------
-- Records of mnt_database
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy`;
CREATE TABLE `mnt_deploy` (
                              `deploy_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                              `app_id` bigint(20) DEFAULT NULL COMMENT '应用编号',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                              `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                              `create_time` datetime DEFAULT NULL,
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              PRIMARY KEY (`deploy_id`) USING BTREE,
                              KEY `FK6sy157pseoxx4fmcqr1vnvvhy` (`app_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='部署管理';

-- ----------------------------
-- Records of mnt_deploy
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy_history
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy_history`;
CREATE TABLE `mnt_deploy_history` (
                                      `history_id` varchar(50) NOT NULL COMMENT 'ID',
                                      `app_name` varchar(255) NOT NULL COMMENT '应用名称',
                                      `deploy_date` datetime NOT NULL COMMENT '部署日期',
                                      `deploy_user` varchar(50) NOT NULL COMMENT '部署用户',
                                      `ip` varchar(20) NOT NULL COMMENT '服务器IP',
                                      `deploy_id` bigint(20) DEFAULT NULL COMMENT '部署编号',
                                      PRIMARY KEY (`history_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='部署历史管理';

-- ----------------------------
-- Records of mnt_deploy_history
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_deploy_server
-- ----------------------------
DROP TABLE IF EXISTS `mnt_deploy_server`;
CREATE TABLE `mnt_deploy_server` (
                                     `deploy_id` bigint(20) NOT NULL COMMENT '部署ID',
                                     `server_id` bigint(20) NOT NULL COMMENT '服务ID',
                                     PRIMARY KEY (`deploy_id`,`server_id`) USING BTREE,
                                     KEY `FKeaaha7jew9a02b3bk9ghols53` (`server_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='应用与服务器关联';

-- ----------------------------
-- Records of mnt_deploy_server
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mnt_server
-- ----------------------------
DROP TABLE IF EXISTS `mnt_server`;
CREATE TABLE `mnt_server` (
                              `server_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                              `account` varchar(50) DEFAULT NULL COMMENT '账号',
                              `ip` varchar(20) DEFAULT NULL COMMENT 'IP地址',
                              `name` varchar(100) DEFAULT NULL COMMENT '名称',
                              `password` varchar(100) DEFAULT NULL COMMENT '密码',
                              `port` int(11) DEFAULT NULL COMMENT '端口',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                              `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                              `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              PRIMARY KEY (`server_id`) USING BTREE,
                              KEY `idx_ip` (`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='服务器管理';

-- ----------------------------
-- Records of mnt_server
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
                            `dept_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                            `pid` bigint(20) DEFAULT NULL COMMENT '上级部门',
                            `sub_count` int(5) DEFAULT 0 COMMENT '子部门数目',
                            `name` varchar(255) NOT NULL COMMENT '名称',
                            `dept_sort` int(5) DEFAULT 999 COMMENT '排序',
                            `enabled` bit(1) NOT NULL COMMENT '状态',
                            `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                            `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                            `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                            `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                            PRIMARY KEY (`dept_id`) USING BTREE,
                            KEY `inx_pid` (`pid`),
                            KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='部门';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`dept_id`, `pid`, `sub_count`, `name`, `dept_sort`, `enabled`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (18, NULL, 1, '疗养中心', 1, b'1', 'admin', 'admin', '2024-07-21 19:19:24', '2025-05-15 21:16:05');
INSERT INTO `sys_dept` (`dept_id`, `pid`, `sub_count`, `name`, `dept_sort`, `enabled`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (19, 18, 0, '训练科', 999, b'1', 'admin', 'admin', '2024-07-30 16:47:48', '2025-05-15 21:16:25');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
                            `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                            `name` varchar(255) NOT NULL COMMENT '字典名称',
                            `description` varchar(255) DEFAULT NULL COMMENT '描述',
                            `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                            `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                            `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                            `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                            PRIMARY KEY (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='数据字典';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` (`dict_id`, `name`, `description`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (1, 'user_status', '用户状态', NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO `sys_dict` (`dict_id`, `name`, `description`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (4, 'dept_status', '部门状态', NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO `sys_dict` (`dict_id`, `name`, `description`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (5, 'job_status', '岗位状态', NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO `sys_dict` (`dict_id`, `name`, `description`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (6, 'gendor', '性别', 'admin', 'admin', '2024-07-21 18:55:40', '2024-07-21 18:55:40');
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_detail
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_detail`;
CREATE TABLE `sys_dict_detail` (
                                   `detail_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                   `dict_id` bigint(11) DEFAULT NULL COMMENT '字典id',
                                   `label` varchar(255) NOT NULL COMMENT '字典标签',
                                   `value` varchar(255) NOT NULL COMMENT '字典值',
                                   `dict_sort` int(5) DEFAULT NULL COMMENT '排序',
                                   `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                                   `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                                   `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                                   `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                   PRIMARY KEY (`detail_id`) USING BTREE,
                                   KEY `FK5tpkputc6d9nboxojdbgnpmyb` (`dict_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='数据字典详情';

-- ----------------------------
-- Records of sys_dict_detail
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (1, 1, '激活', 'true', 1, NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (2, 1, '禁用', 'false', 2, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (3, 4, '启用', 'true', 1, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (4, 4, '停用', 'false', 2, NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (5, 5, '启用', 'true', 1, NULL, NULL, NULL, NULL);
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (6, 5, '停用', 'false', 2, NULL, NULL, '2019-10-27 20:31:36', NULL);
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (7, 6, '男', '男', 1, 'admin', 'admin', '2024-07-21 18:55:55', '2024-07-21 18:55:55');
INSERT INTO `sys_dict_detail` (`detail_id`, `dict_id`, `label`, `value`, `dict_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (8, 6, '女', '女', 2, 'admin', 'admin', '2024-07-21 18:56:04', '2024-07-21 18:56:04');
COMMIT;

-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE `sys_job` (
                           `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                           `name` varchar(180) NOT NULL COMMENT '岗位名称',
                           `enabled` bit(1) NOT NULL COMMENT '岗位状态',
                           `job_sort` int(5) DEFAULT NULL COMMENT '排序',
                           `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                           `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                           `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                           `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                           PRIMARY KEY (`job_id`) USING BTREE,
                           UNIQUE KEY `uniq_name` (`name`),
                           KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='岗位';

-- ----------------------------
-- Records of sys_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_job` (`job_id`, `name`, `enabled`, `job_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (13, '医生', b'1', 1, 'admin', 'admin', '2024-07-21 19:20:08', '2024-07-21 19:20:08');
INSERT INTO `sys_job` (`job_id`, `name`, `enabled`, `job_sort`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (14, '护士', b'1', 999, 'admin', 'admin', '2024-07-28 16:38:07', '2024-07-28 16:38:07');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
                           `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                           `description` varchar(255) DEFAULT NULL,
                           `log_type` varchar(10) DEFAULT NULL,
                           `method` varchar(255) DEFAULT NULL,
                           `params` text DEFAULT NULL,
                           `request_ip` varchar(255) DEFAULT NULL,
                           `time` bigint(20) DEFAULT NULL,
                           `username` varchar(255) DEFAULT NULL,
                           `address` varchar(255) DEFAULT NULL,
                           `browser` varchar(255) DEFAULT NULL,
                           `exception_detail` text DEFAULT NULL,
                           `create_time` datetime DEFAULT NULL,
                           PRIMARY KEY (`log_id`) USING BTREE,
                           KEY `log_create_time_index` (`create_time`),
                           KEY `inx_log_type` (`log_type`)
) ENGINE=InnoDB AUTO_INCREMENT=5750 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='系统日志';

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5740, '用户登录', 'INFO', 'me.zhengjie.modules.security.rest.AuthorizationController.login()', '{\"username\":\"admin\"}', '192.168.31.185', 798, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:22:12');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5741, '查询人次信息统计', 'INFO', 'me.zhengjie.rest.TrainStatisticController.queryTrainStatistic()', '', '192.168.31.185', 168, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:22:13');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5742, '查询plane', 'INFO', 'me.zhengjie.rest.PlaneController.queryTrainPlane()', '', '192.168.31.185', 28, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:22:25');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5743, '查询疗养员', 'INFO', 'me.zhengjie.rest.PilotController.queryTrainPilot()', '', '192.168.31.185', 38, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:22:27');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5744, '查询item', 'INFO', 'me.zhengjie.rest.ItemController.queryTrainItem()', '', '192.168.31.185', 31, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:22:28');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5745, '查询train', 'INFO', 'me.zhengjie.rest.TrainController.queryTrain()', '', '192.168.31.185', 56, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:22:28');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5746, '查询train', 'INFO', 'me.zhengjie.rest.TrainController.queryTrain()', '', '192.168.31.185', 19, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:24:17');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5747, '查询plane', 'INFO', 'me.zhengjie.rest.PlaneController.queryTrainPlane()', '', '192.168.31.185', 14, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:24:22');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5748, '查询item', 'INFO', 'me.zhengjie.rest.ItemController.queryTrainItem()', '', '192.168.31.185', 16, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:24:22');
INSERT INTO `sys_log` (`log_id`, `description`, `log_type`, `method`, `params`, `request_ip`, `time`, `username`, `address`, `browser`, `exception_detail`, `create_time`) VALUES (5749, '查询疗养员', 'INFO', 'me.zhengjie.rest.PilotController.queryTrainPilot()', '', '192.168.31.185', 16, 'admin', '内网IP', 'Chrome 137', NULL, '2025-06-29 16:24:22');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
                            `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                            `pid` bigint(20) DEFAULT NULL COMMENT '上级菜单ID',
                            `sub_count` int(5) DEFAULT 0 COMMENT '子菜单数目',
                            `type` int(11) DEFAULT NULL COMMENT '菜单类型',
                            `title` varchar(100) DEFAULT NULL COMMENT '菜单标题',
                            `name` varchar(100) DEFAULT NULL COMMENT '组件名称',
                            `component` varchar(255) DEFAULT NULL COMMENT '组件',
                            `menu_sort` int(5) DEFAULT NULL COMMENT '排序',
                            `icon` varchar(255) DEFAULT NULL COMMENT '图标',
                            `path` varchar(255) DEFAULT NULL COMMENT '链接地址',
                            `i_frame` bit(1) DEFAULT NULL COMMENT '是否外链',
                            `cache` bit(1) DEFAULT b'0' COMMENT '缓存',
                            `hidden` bit(1) DEFAULT b'0' COMMENT '隐藏',
                            `permission` varchar(255) DEFAULT NULL COMMENT '权限',
                            `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                            `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                            `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                            `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                            PRIMARY KEY (`menu_id`) USING BTREE,
                            UNIQUE KEY `uniq_title` (`title`),
                            UNIQUE KEY `uniq_name` (`name`),
                            KEY `inx_pid` (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='系统菜单';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (1, NULL, 7, 0, '系统管理', NULL, NULL, 1, 'system', 'system', b'0', b'0', b'0', NULL, NULL, NULL, '2018-12-18 15:11:29', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (2, 1, 3, 1, '用户管理', 'User', 'system/user/index', 2, 'peoples', 'user', b'0', b'0', b'0', 'user:list', NULL, NULL, '2018-12-18 15:14:44', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (3, 1, 3, 1, '角色管理', 'Role', 'system/role/index', 3, 'role', 'role', b'0', b'0', b'0', 'roles:list', NULL, NULL, '2018-12-18 15:16:07', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (5, 1, 3, 1, '菜单管理', 'Menu', 'system/menu/index', 5, 'menu', 'menu', b'0', b'0', b'0', 'menu:list', NULL, NULL, '2018-12-18 15:17:28', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (6, NULL, 5, 0, '系统监控', NULL, NULL, 10, 'monitor', 'monitor', b'0', b'0', b'1', NULL, NULL, 'admin', '2018-12-18 15:17:48', '2025-05-15 21:15:22');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (7, 6, 0, 1, '操作日志', 'Log', 'monitor/log/index', 11, 'log', 'logs', b'0', b'1', b'0', NULL, NULL, 'admin', '2018-12-18 15:18:26', '2020-06-06 13:11:57');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (9, 6, 0, 1, 'SQL监控', 'Sql', 'monitor/sql/index', 18, 'sqlMonitor', 'druid', b'0', b'0', b'0', NULL, NULL, NULL, '2018-12-18 15:19:34', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (10, NULL, 5, 0, '组件管理', NULL, NULL, 50, 'zujian', 'components', b'0', b'0', b'0', NULL, NULL, NULL, '2018-12-19 13:38:16', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (11, 10, 0, 1, '图标库', 'Icons', 'components/icons/index', 51, 'icon', 'icon', b'0', b'0', b'0', NULL, NULL, NULL, '2018-12-19 13:38:49', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (14, 36, 0, 1, '邮件工具', 'Email', 'tools/email/index', 35, 'email', 'email', b'0', b'0', b'0', NULL, NULL, NULL, '2018-12-27 10:13:09', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (15, 10, 0, 1, '富文本', 'Editor', 'components/Editor', 52, 'fwb', 'tinymce', b'0', b'0', b'0', NULL, NULL, NULL, '2018-12-27 11:58:25', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (18, 36, 3, 1, '存储管理', 'Storage', 'tools/storage/index', 34, 'qiniu', 'storage', b'0', b'0', b'0', 'storage:list', NULL, NULL, '2018-12-31 11:12:15', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (19, 36, 0, 1, '支付宝工具', 'AliPay', 'tools/aliPay/index', 37, 'alipay', 'aliPay', b'0', b'0', b'0', NULL, NULL, NULL, '2018-12-31 14:52:38', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (28, 1, 3, 1, '任务调度', 'Timing', 'system/timing/index', 999, 'timing', 'timing', b'0', b'0', b'1', 'timing:list', NULL, 'admin', '2019-01-07 20:34:40', '2025-05-15 21:15:36');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (30, 36, 0, 1, '代码生成', 'GeneratorIndex', 'generator/index', 32, 'dev', 'generator', b'0', b'1', b'0', NULL, NULL, NULL, '2019-01-11 15:45:55', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (32, 6, 0, 1, '异常日志', 'ErrorLog', 'monitor/log/errorLog', 12, 'error', 'errorLog', b'0', b'0', b'0', NULL, NULL, NULL, '2019-01-13 13:49:03', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (33, 10, 0, 1, 'Markdown', 'Markdown', 'components/MarkDown', 53, 'markdown', 'markdown', b'0', b'0', b'0', NULL, NULL, NULL, '2019-03-08 13:46:44', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (34, 10, 0, 1, 'Yaml编辑器', 'YamlEdit', 'components/YamlEdit', 54, 'dev', 'yaml', b'0', b'0', b'0', NULL, NULL, NULL, '2019-03-08 15:49:40', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (35, 1, 3, 1, '部门管理', 'Dept', 'system/dept/index', 6, 'dept', 'dept', b'0', b'0', b'0', 'dept:list', NULL, NULL, '2019-03-25 09:46:00', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (36, NULL, 7, 0, '系统工具', NULL, '', 30, 'sys-tools', 'sys-tools', b'0', b'0', b'1', NULL, NULL, 'admin', '2019-03-29 10:57:35', '2025-05-15 20:58:39');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (37, 1, 3, 1, '岗位管理', 'Job', 'system/job/index', 7, 'Steve-Jobs', 'job', b'0', b'0', b'0', 'job:list', NULL, NULL, '2019-03-29 13:51:18', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (38, 36, 0, 1, '接口文档', 'Swagger', 'tools/swagger/index', 36, 'swagger', 'swagger2', b'0', b'0', b'0', NULL, NULL, NULL, '2019-03-29 19:57:53', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (39, 1, 3, 1, '字典管理', 'Dict', 'system/dict/index', 8, 'dictionary', 'dict', b'0', b'0', b'1', 'dict:list', NULL, 'admin', '2019-04-10 11:49:04', '2025-05-15 21:15:10');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (41, 6, 0, 1, '在线用户', 'OnlineUser', 'monitor/online/index', 10, 'Steve-Jobs', 'online', b'0', b'0', b'0', NULL, NULL, NULL, '2019-10-26 22:08:43', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (44, 2, 0, 2, '用户新增', NULL, '', 2, '', '', b'0', b'0', b'0', 'user:add', NULL, NULL, '2019-10-29 10:59:46', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (45, 2, 0, 2, '用户编辑', NULL, '', 3, '', '', b'0', b'0', b'0', 'user:edit', NULL, NULL, '2019-10-29 11:00:08', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (46, 2, 0, 2, '用户删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'user:del', NULL, NULL, '2019-10-29 11:00:23', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (48, 3, 0, 2, '角色创建', NULL, '', 2, '', '', b'0', b'0', b'0', 'roles:add', NULL, NULL, '2019-10-29 12:45:34', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (49, 3, 0, 2, '角色修改', NULL, '', 3, '', '', b'0', b'0', b'0', 'roles:edit', NULL, NULL, '2019-10-29 12:46:16', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (50, 3, 0, 2, '角色删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'roles:del', NULL, NULL, '2019-10-29 12:46:51', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (52, 5, 0, 2, '菜单新增', NULL, '', 2, '', '', b'0', b'0', b'0', 'menu:add', NULL, NULL, '2019-10-29 12:55:07', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (53, 5, 0, 2, '菜单编辑', NULL, '', 3, '', '', b'0', b'0', b'0', 'menu:edit', NULL, NULL, '2019-10-29 12:55:40', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (54, 5, 0, 2, '菜单删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'menu:del', NULL, NULL, '2019-10-29 12:56:00', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (56, 35, 0, 2, '部门新增', NULL, '', 2, '', '', b'0', b'0', b'0', 'dept:add', NULL, NULL, '2019-10-29 12:57:09', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (57, 35, 0, 2, '部门编辑', NULL, '', 3, '', '', b'0', b'0', b'0', 'dept:edit', NULL, NULL, '2019-10-29 12:57:27', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (58, 35, 0, 2, '部门删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'dept:del', NULL, NULL, '2019-10-29 12:57:41', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (60, 37, 0, 2, '岗位新增', NULL, '', 2, '', '', b'0', b'0', b'0', 'job:add', NULL, NULL, '2019-10-29 12:58:27', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (61, 37, 0, 2, '岗位编辑', NULL, '', 3, '', '', b'0', b'0', b'0', 'job:edit', NULL, NULL, '2019-10-29 12:58:45', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (62, 37, 0, 2, '岗位删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'job:del', NULL, NULL, '2019-10-29 12:59:04', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (64, 39, 0, 2, '字典新增', NULL, '', 2, '', '', b'0', b'0', b'0', 'dict:add', NULL, NULL, '2019-10-29 13:00:17', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (65, 39, 0, 2, '字典编辑', NULL, '', 3, '', '', b'0', b'0', b'0', 'dict:edit', NULL, NULL, '2019-10-29 13:00:42', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (66, 39, 0, 2, '字典删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'dict:del', NULL, NULL, '2019-10-29 13:00:59', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (73, 28, 0, 2, '任务新增', NULL, '', 2, '', '', b'0', b'0', b'0', 'timing:add', NULL, NULL, '2019-10-29 13:07:28', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (74, 28, 0, 2, '任务编辑', NULL, '', 3, '', '', b'0', b'0', b'0', 'timing:edit', NULL, NULL, '2019-10-29 13:07:41', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (75, 28, 0, 2, '任务删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'timing:del', NULL, NULL, '2019-10-29 13:07:54', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (77, 18, 0, 2, '上传文件', NULL, '', 2, '', '', b'0', b'0', b'0', 'storage:add', NULL, NULL, '2019-10-29 13:09:09', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (78, 18, 0, 2, '文件编辑', NULL, '', 3, '', '', b'0', b'0', b'0', 'storage:edit', NULL, NULL, '2019-10-29 13:09:22', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (79, 18, 0, 2, '文件删除', NULL, '', 4, '', '', b'0', b'0', b'0', 'storage:del', NULL, NULL, '2019-10-29 13:09:34', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (80, 6, 0, 1, '服务监控', 'ServerMonitor', 'monitor/server/index', 14, 'codeConsole', 'server', b'0', b'0', b'0', 'monitor:list', NULL, 'admin', '2019-11-07 13:06:39', '2020-05-04 18:20:50');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (82, 36, 0, 1, '生成配置', 'GeneratorConfig', 'generator/config', 33, 'dev', 'generator/config/:tableName', b'0', b'1', b'1', '', NULL, NULL, '2019-11-17 20:08:56', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (83, 10, 0, 1, '图表库', 'Echarts', 'components/Echarts', 50, 'chart', 'echarts', b'0', b'1', b'0', '', NULL, NULL, '2019-11-21 09:04:32', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (90, NULL, 5, 1, '运维管理', 'Mnt', '', 20, 'mnt', 'mnt', b'0', b'0', b'1', NULL, NULL, 'admin', '2019-11-09 10:31:08', '2025-05-15 20:58:10');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (92, 90, 3, 1, '服务器', 'ServerDeploy', 'mnt/server/index', 22, 'server', 'mnt/serverDeploy', b'0', b'0', b'0', 'serverDeploy:list', NULL, NULL, '2019-11-10 10:29:25', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (93, 90, 3, 1, '应用管理', 'App', 'mnt/app/index', 23, 'app', 'mnt/app', b'0', b'0', b'0', 'app:list', NULL, NULL, '2019-11-10 11:05:16', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (94, 90, 3, 1, '部署管理', 'Deploy', 'mnt/deploy/index', 24, 'deploy', 'mnt/deploy', b'0', b'0', b'0', 'deploy:list', NULL, NULL, '2019-11-10 15:56:55', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (97, 90, 1, 1, '部署备份', 'DeployHistory', 'mnt/deployHistory/index', 25, 'backup', 'mnt/deployHistory', b'0', b'0', b'0', 'deployHistory:list', NULL, NULL, '2019-11-10 16:49:44', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (98, 90, 3, 1, '数据库管理', 'Database', 'mnt/database/index', 26, 'database', 'mnt/database', b'0', b'0', b'0', 'database:list', NULL, NULL, '2019-11-10 20:40:04', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (102, 97, 0, 2, '删除', NULL, '', 999, '', '', b'0', b'0', b'0', 'deployHistory:del', NULL, NULL, '2019-11-17 09:32:48', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (103, 92, 0, 2, '服务器新增', NULL, '', 999, '', '', b'0', b'0', b'0', 'serverDeploy:add', NULL, NULL, '2019-11-17 11:08:33', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (104, 92, 0, 2, '服务器编辑', NULL, '', 999, '', '', b'0', b'0', b'0', 'serverDeploy:edit', NULL, NULL, '2019-11-17 11:08:57', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (105, 92, 0, 2, '服务器删除', NULL, '', 999, '', '', b'0', b'0', b'0', 'serverDeploy:del', NULL, NULL, '2019-11-17 11:09:15', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (106, 93, 0, 2, '应用新增', NULL, '', 999, '', '', b'0', b'0', b'0', 'app:add', NULL, NULL, '2019-11-17 11:10:03', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (107, 93, 0, 2, '应用编辑', NULL, '', 999, '', '', b'0', b'0', b'0', 'app:edit', NULL, NULL, '2019-11-17 11:10:28', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (108, 93, 0, 2, '应用删除', NULL, '', 999, '', '', b'0', b'0', b'0', 'app:del', NULL, NULL, '2019-11-17 11:10:55', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (109, 94, 0, 2, '部署新增', NULL, '', 999, '', '', b'0', b'0', b'0', 'deploy:add', NULL, NULL, '2019-11-17 11:11:22', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (110, 94, 0, 2, '部署编辑', NULL, '', 999, '', '', b'0', b'0', b'0', 'deploy:edit', NULL, NULL, '2019-11-17 11:11:41', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (111, 94, 0, 2, '部署删除', NULL, '', 999, '', '', b'0', b'0', b'0', 'deploy:del', NULL, NULL, '2019-11-17 11:12:01', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (112, 98, 0, 2, '数据库新增', NULL, '', 999, '', '', b'0', b'0', b'0', 'database:add', NULL, NULL, '2019-11-17 11:12:43', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (113, 98, 0, 2, '数据库编辑', NULL, '', 999, '', '', b'0', b'0', b'0', 'database:edit', NULL, NULL, '2019-11-17 11:12:58', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (114, 98, 0, 2, '数据库删除', NULL, '', 999, '', '', b'0', b'0', b'0', 'database:del', NULL, NULL, '2019-11-17 11:13:14', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (116, 36, 0, 1, '生成预览', 'Preview', 'generator/preview', 999, 'java', 'generator/preview/:tableName', b'0', b'1', b'1', NULL, NULL, NULL, '2019-11-26 14:54:36', NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (118, NULL, 5, 1, '训练管理', NULL, NULL, 1, 'pilot', 'train', b'0', b'0', b'0', NULL, 'admin', 'admin', '2024-07-21 19:12:59', '2024-07-21 19:12:59');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (119, 118, 0, 1, '疗养员管理', 'Pilot', 'train/pilot/index', 1, 'chart', 'pilot', b'0', b'0', b'0', 'pilot:list', 'admin', 'admin', '2024-07-21 19:14:54', '2024-07-21 19:14:54');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (120, 118, 2, 1, '档案管理', 'Doc', 'train/train/index', 999, 'doc', 'train', b'0', b'0', b'0', 'train:list', 'admin', 'admin', '2024-07-21 21:17:38', '2025-05-15 20:18:26');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (121, 118, 0, 1, '机器管理', 'Plane', 'train/plane/index', 999, 'develop', 'plane', b'0', b'0', b'0', 'plane:list', 'admin', 'admin', '2024-07-28 11:24:22', '2025-05-15 21:28:58');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (122, 118, 2, 1, '训练项目管理', 'Item', 'train/item/index', 999, 'list', 'item', b'0', b'0', b'0', 'item:list', 'admin', 'admin', '2024-07-28 15:58:00', '2024-07-28 15:58:00');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (126, 118, 0, 1, '主观感受', 'Feel', 'train/feel/index', 999, 'size', 'feel', b'0', b'0', b'0', 'feel:list', 'admin', 'admin', '2025-05-15 20:54:20', '2025-05-15 21:01:54');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (127, 120, 0, 2, '新增档案', NULL, NULL, 999, NULL, NULL, b'0', b'0', b'0', 'train:add', 'admin', 'admin', '2025-06-21 20:38:40', '2025-06-21 20:38:40');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (128, 120, 0, 2, '编辑档案', NULL, NULL, 999, NULL, NULL, b'0', b'0', b'0', 'train:edit', 'admin', 'admin', '2025-06-21 20:39:13', '2025-06-21 20:39:13');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (129, 122, 0, 2, '编辑项目详情', NULL, NULL, 999, NULL, NULL, b'0', b'0', b'0', 'itemDetail:edit', 'admin', 'admin', '2025-06-21 21:35:01', '2025-06-21 21:35:01');
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (130, 122, 0, 2, '新增项目详情', NULL, NULL, 999, NULL, NULL, b'0', b'0', b'0', 'itemDetail:add', 'admin', 'admin', '2025-06-21 21:35:48', '2025-06-21 21:35:48');
COMMIT;

-- ----------------------------
-- Table structure for sys_quartz_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_quartz_job`;
CREATE TABLE `sys_quartz_job` (
                                  `job_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                  `bean_name` varchar(255) DEFAULT NULL COMMENT 'Spring Bean名称',
                                  `cron_expression` varchar(255) DEFAULT NULL COMMENT 'cron 表达式',
                                  `is_pause` bit(1) DEFAULT NULL COMMENT '状态：1暂停、0启用',
                                  `job_name` varchar(255) DEFAULT NULL COMMENT '任务名称',
                                  `method_name` varchar(255) DEFAULT NULL COMMENT '方法名称',
                                  `params` varchar(255) DEFAULT NULL COMMENT '参数',
                                  `description` varchar(255) DEFAULT NULL COMMENT '备注',
                                  `person_in_charge` varchar(100) DEFAULT NULL COMMENT '负责人',
                                  `email` varchar(100) DEFAULT NULL COMMENT '报警邮箱',
                                  `sub_task` varchar(100) DEFAULT NULL COMMENT '子任务ID',
                                  `pause_after_failure` bit(1) DEFAULT NULL COMMENT '任务失败后是否暂停',
                                  `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                                  `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                                  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                                  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                  PRIMARY KEY (`job_id`) USING BTREE,
                                  KEY `inx_is_pause` (`is_pause`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='定时任务';

-- ----------------------------
-- Records of sys_quartz_job
-- ----------------------------
BEGIN;
INSERT INTO `sys_quartz_job` (`job_id`, `bean_name`, `cron_expression`, `is_pause`, `job_name`, `method_name`, `params`, `description`, `person_in_charge`, `email`, `sub_task`, `pause_after_failure`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (2, 'testTask', '0/5 * * * * ?', b'1', '测试1', 'run1', 'test', '带参测试，多参使用json', '测试', NULL, NULL, NULL, NULL, 'admin', '2019-08-22 14:08:29', '2020-05-24 13:58:33');
INSERT INTO `sys_quartz_job` (`job_id`, `bean_name`, `cron_expression`, `is_pause`, `job_name`, `method_name`, `params`, `description`, `person_in_charge`, `email`, `sub_task`, `pause_after_failure`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (3, 'testTask', '0/5 * * * * ?', b'1', '测试', 'run', '', '不带参测试', 'Zheng Jie', '', '5,6', b'1', NULL, 'admin', '2019-09-26 16:44:39', '2020-05-24 14:48:12');
INSERT INTO `sys_quartz_job` (`job_id`, `bean_name`, `cron_expression`, `is_pause`, `job_name`, `method_name`, `params`, `description`, `person_in_charge`, `email`, `sub_task`, `pause_after_failure`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (5, 'Test', '0/5 * * * * ?', b'1', '任务告警测试', 'run', NULL, '测试', 'test', '', NULL, b'1', 'admin', 'admin', '2020-05-05 20:32:41', '2020-05-05 20:36:13');
INSERT INTO `sys_quartz_job` (`job_id`, `bean_name`, `cron_expression`, `is_pause`, `job_name`, `method_name`, `params`, `description`, `person_in_charge`, `email`, `sub_task`, `pause_after_failure`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (6, 'testTask', '0/5 * * * * ?', b'1', '测试3', 'run2', NULL, '测试3', 'Zheng Jie', '', NULL, b'1', 'admin', 'admin', '2020-05-05 20:35:41', '2020-05-05 20:36:07');
COMMIT;

-- ----------------------------
-- Table structure for sys_quartz_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_quartz_log`;
CREATE TABLE `sys_quartz_log` (
                                  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                  `bean_name` varchar(255) DEFAULT NULL,
                                  `create_time` datetime DEFAULT NULL,
                                  `cron_expression` varchar(255) DEFAULT NULL,
                                  `exception_detail` text DEFAULT NULL,
                                  `is_success` bit(1) DEFAULT NULL,
                                  `job_name` varchar(255) DEFAULT NULL,
                                  `method_name` varchar(255) DEFAULT NULL,
                                  `params` varchar(255) DEFAULT NULL,
                                  `time` bigint(20) DEFAULT NULL,
                                  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='定时任务日志';

-- ----------------------------
-- Records of sys_quartz_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
                            `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                            `name` varchar(100) NOT NULL COMMENT '名称',
                            `level` int(50) DEFAULT NULL COMMENT '角色级别',
                            `description` varchar(255) DEFAULT NULL COMMENT '描述',
                            `data_scope` varchar(255) DEFAULT NULL COMMENT '数据权限',
                            `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                            `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                            `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                            `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                            PRIMARY KEY (`role_id`) USING BTREE,
                            UNIQUE KEY `uniq_name` (`name`),
                            KEY `role_name_index` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`role_id`, `name`, `level`, `description`, `data_scope`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (1, '超级管理员', 1, '-', '全部', NULL, 'admin', '2018-11-23 11:04:37', '2020-08-06 16:10:24');
INSERT INTO `sys_role` (`role_id`, `name`, `level`, `description`, `data_scope`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (2, '普通用户', 2, '-', '本级', NULL, 'admin', '2018-11-23 13:09:06', '2020-09-05 10:45:12');
COMMIT;

-- ----------------------------
-- Table structure for sys_roles_depts
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_depts`;
CREATE TABLE `sys_roles_depts` (
                                   `role_id` bigint(20) NOT NULL,
                                   `dept_id` bigint(20) NOT NULL,
                                   PRIMARY KEY (`role_id`,`dept_id`) USING BTREE,
                                   KEY `FK7qg6itn5ajdoa9h9o78v9ksur` (`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='角色部门关联';

-- ----------------------------
-- Records of sys_roles_depts
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_roles_menus
-- ----------------------------
DROP TABLE IF EXISTS `sys_roles_menus`;
CREATE TABLE `sys_roles_menus` (
                                   `menu_id` bigint(20) NOT NULL COMMENT '菜单ID',
                                   `role_id` bigint(20) NOT NULL COMMENT '角色ID',
                                   PRIMARY KEY (`menu_id`,`role_id`) USING BTREE,
                                   KEY `FKcngg2qadojhi3a651a5adkvbq` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='角色菜单关联';

-- ----------------------------
-- Records of sys_roles_menus
-- ----------------------------
BEGIN;
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (1, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (2, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (3, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (5, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (6, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (7, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (9, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (14, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (18, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (19, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (28, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (30, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (32, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (35, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (36, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (37, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (38, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (39, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (41, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (44, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (45, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (46, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (48, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (49, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (50, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (52, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (53, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (54, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (56, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (57, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (58, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (60, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (61, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (62, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (64, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (65, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (66, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (73, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (74, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (75, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (77, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (78, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (79, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (80, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (82, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (90, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (92, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (93, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (94, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (97, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (98, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (102, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (103, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (104, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (105, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (106, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (107, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (108, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (109, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (110, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (111, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (112, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (113, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (114, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (116, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (118, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (119, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (120, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (121, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (122, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (126, 1);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (118, 2);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (119, 2);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (120, 2);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (121, 2);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (122, 2);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (126, 2);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (127, 2);
INSERT INTO `sys_roles_menus` (`menu_id`, `role_id`) VALUES (128, 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
                            `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                            `dept_id` bigint(20) DEFAULT NULL COMMENT '部门名称',
                            `username` varchar(180) DEFAULT NULL COMMENT '用户名',
                            `nick_name` varchar(255) DEFAULT NULL COMMENT '昵称',
                            `gender` varchar(2) DEFAULT NULL COMMENT '性别',
                            `phone` varchar(255) DEFAULT NULL COMMENT '手机号码',
                            `email` varchar(180) DEFAULT NULL COMMENT '邮箱',
                            `avatar_name` varchar(255) DEFAULT NULL COMMENT '头像地址',
                            `avatar_path` varchar(255) DEFAULT NULL COMMENT '头像真实路径',
                            `password` varchar(255) DEFAULT NULL COMMENT '密码',
                            `is_admin` bit(1) DEFAULT b'0' COMMENT '是否为admin账号',
                            `enabled` bit(1) DEFAULT NULL COMMENT '状态：1启用、0禁用',
                            `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                            `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                            `pwd_reset_time` datetime DEFAULT NULL COMMENT '修改密码的时间',
                            `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                            `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                            PRIMARY KEY (`user_id`) USING BTREE,
                            UNIQUE KEY `UK_kpubos9gc2cvtkb0thktkbkes` (`email`) USING BTREE,
                            UNIQUE KEY `username` (`username`) USING BTREE,
                            UNIQUE KEY `uniq_username` (`username`),
                            UNIQUE KEY `uniq_email` (`email`),
                            KEY `FK5rwmryny6jthaaxkogownknqp` (`dept_id`) USING BTREE,
                            KEY `inx_enabled` (`enabled`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`user_id`, `dept_id`, `username`, `nick_name`, `gender`, `phone`, `email`, `avatar_name`, `avatar_path`, `password`, `is_admin`, `enabled`, `create_by`, `update_by`, `pwd_reset_time`, `create_time`, `update_time`) VALUES (1, 18, 'admin', '管理员', '男', '18888888888', '201507802@qq.com', '', '', '$2a$10$Egp1/gvFlt7zhlXVfEFw4OfWQCGPw0ClmMcc6FjTnvXNRVf9zdMRa', b'1', b'1', NULL, 'admin', '2020-05-03 16:38:31', '2018-08-23 09:11:56', '2020-09-05 10:43:31');
INSERT INTO `sys_user` (`user_id`, `dept_id`, `username`, `nick_name`, `gender`, `phone`, `email`, `avatar_name`, `avatar_path`, `password`, `is_admin`, `enabled`, `create_by`, `update_by`, `pwd_reset_time`, `create_time`, `update_time`) VALUES (2, 18, 'test', '测试', '男', '19999999999', '231@qq.com', NULL, NULL, '$2a$10$4XcyudOYTSz6fue6KFNMHeUQnCX5jbBQypLEnGk1PmekXt5c95JcK', b'0', b'1', 'admin', 'admin', NULL, '2020-05-05 11:15:49', '2020-09-05 10:43:38');
INSERT INTO `sys_user` (`user_id`, `dept_id`, `username`, `nick_name`, `gender`, `phone`, `email`, `avatar_name`, `avatar_path`, `password`, `is_admin`, `enabled`, `create_by`, `update_by`, `pwd_reset_time`, `create_time`, `update_time`) VALUES (3, 19, 'doctor', '11', '男', '19999999998', '111@qq.com', NULL, NULL, '$2a$10$spe.SYQskAMaJDhqH7Qmd.Km0jFDFONFGKoD4eVm0lyV2pHTBnBFa', b'0', b'1', 'admin', 'admin', NULL, '2024-07-30 16:50:33', '2024-07-30 16:50:33');
COMMIT;

-- ----------------------------
-- Table structure for sys_users_jobs
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_jobs`;
CREATE TABLE `sys_users_jobs` (
                                  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
                                  `job_id` bigint(20) NOT NULL COMMENT '岗位ID',
                                  PRIMARY KEY (`user_id`,`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

-- ----------------------------
-- Records of sys_users_jobs
-- ----------------------------
BEGIN;
INSERT INTO `sys_users_jobs` (`user_id`, `job_id`) VALUES (1, 13);
INSERT INTO `sys_users_jobs` (`user_id`, `job_id`) VALUES (2, 13);
INSERT INTO `sys_users_jobs` (`user_id`, `job_id`) VALUES (3, 13);
COMMIT;

-- ----------------------------
-- Table structure for sys_users_roles
-- ----------------------------
DROP TABLE IF EXISTS `sys_users_roles`;
CREATE TABLE `sys_users_roles` (
                                   `user_id` bigint(20) NOT NULL COMMENT '用户ID',
                                   `role_id` bigint(20) NOT NULL COMMENT '角色ID',
                                   PRIMARY KEY (`user_id`,`role_id`) USING BTREE,
                                   KEY `FKq4eq273l04bpu4efj0jd0jb98` (`role_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='用户角色关联';

-- ----------------------------
-- Records of sys_users_roles
-- ----------------------------
BEGIN;
INSERT INTO `sys_users_roles` (`user_id`, `role_id`) VALUES (1, 1);
INSERT INTO `sys_users_roles` (`user_id`, `role_id`) VALUES (2, 2);
INSERT INTO `sys_users_roles` (`user_id`, `role_id`) VALUES (3, 2);
COMMIT;

-- ----------------------------
-- Table structure for tool_alipay_config
-- ----------------------------
DROP TABLE IF EXISTS `tool_alipay_config`;
CREATE TABLE `tool_alipay_config` (
                                      `config_id` bigint(20) NOT NULL COMMENT 'ID',
                                      `app_id` varchar(255) DEFAULT NULL COMMENT '应用ID',
                                      `charset` varchar(255) DEFAULT NULL COMMENT '编码',
                                      `format` varchar(255) DEFAULT NULL COMMENT '类型 固定格式json',
                                      `gateway_url` varchar(255) DEFAULT NULL COMMENT '网关地址',
                                      `notify_url` varchar(255) DEFAULT NULL COMMENT '异步回调',
                                      `private_key` text DEFAULT NULL COMMENT '私钥',
                                      `public_key` text DEFAULT NULL COMMENT '公钥',
                                      `return_url` varchar(255) DEFAULT NULL COMMENT '回调地址',
                                      `sign_type` varchar(255) DEFAULT NULL COMMENT '签名方式',
                                      `sys_service_provider_id` varchar(255) DEFAULT NULL COMMENT '商户号',
                                      PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='支付宝配置类';

-- ----------------------------
-- Records of tool_alipay_config
-- ----------------------------
BEGIN;
INSERT INTO `tool_alipay_config` (`config_id`, `app_id`, `charset`, `format`, `gateway_url`, `notify_url`, `private_key`, `public_key`, `return_url`, `sign_type`, `sys_service_provider_id`) VALUES (1, '2016091700532697', 'utf-8', 'JSON', 'https://openapi.alipaydev.com/gateway.do', 'http://api.auauz.net/api/aliPay/notify', 'MIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQC5js8sInU10AJ0cAQ8UMMyXrQ+oHZEkVt5lBwsStmTJ7YikVYgbskx1YYEXTojRsWCb+SH/kDmDU4pK/u91SJ4KFCRMF2411piYuXU/jF96zKrADznYh/zAraqT6hvAIVtQAlMHN53nx16rLzZ/8jDEkaSwT7+HvHiS+7sxSojnu/3oV7BtgISoUNstmSe8WpWHOaWv19xyS+Mce9MY4BfseFhzTICUymUQdd/8hXA28/H6osUfAgsnxAKv7Wil3aJSgaJczWuflYOve0dJ3InZkhw5Cvr0atwpk8YKBQjy5CdkoHqvkOcIB+cYHXJKzOE5tqU7inSwVbHzOLQ3XbnAgMBAAECggEAVJp5eT0Ixg1eYSqFs9568WdetUNCSUchNxDBu6wxAbhUgfRUGZuJnnAll63OCTGGck+EGkFh48JjRcBpGoeoHLL88QXlZZbC/iLrea6gcDIhuvfzzOffe1RcZtDFEj9hlotg8dQj1tS0gy9pN9g4+EBH7zeu+fyv+qb2e/v1l6FkISXUjpkD7RLQr3ykjiiEw9BpeKb7j5s7Kdx1NNIzhkcQKNqlk8JrTGDNInbDM6inZfwwIO2R1DHinwdfKWkvOTODTYa2MoAvVMFT9Bec9FbLpoWp7ogv1JMV9svgrcF9XLzANZ/OQvkbe9TV9GWYvIbxN6qwQioKCWO4GPnCAQKBgQDgW5MgfhX8yjXqoaUy/d1VjI8dHeIyw8d+OBAYwaxRSlCfyQ+tieWcR2HdTzPca0T0GkWcKZm0ei5xRURgxt4DUDLXNh26HG0qObbtLJdu/AuBUuCqgOiLqJ2f1uIbrz6OZUHns+bT/jGW2Ws8+C13zTCZkZt9CaQsrp3QOGDx5wKBgQDTul39hp3ZPwGNFeZdkGoUoViOSd5Lhowd5wYMGAEXWRLlU8z+smT5v0POz9JnIbCRchIY2FAPKRdVTICzmPk2EPJFxYTcwaNbVqL6lN7J2IlXXMiit5QbiLauo55w7plwV6LQmKm9KV7JsZs5XwqF7CEovI7GevFzyD3w+uizAQKBgC3LY1eRhOlpWOIAhpjG6qOoohmeXOphvdmMlfSHq6WYFqbWwmV4rS5d/6LNpNdL6fItXqIGd8I34jzql49taCmi+A2nlR/E559j0mvM20gjGDIYeZUz5MOE8k+K6/IcrhcgofgqZ2ZED1ksHdB/E8DNWCswZl16V1FrfvjeWSNnAoGAMrBplCrIW5xz+J0Hm9rZKrs+AkK5D4fUv8vxbK/KgxZ2KaUYbNm0xv39c+PZUYuFRCz1HDGdaSPDTE6WeWjkMQd5mS6ikl9hhpqFRkyh0d0fdGToO9yLftQKOGE/q3XUEktI1XvXF0xyPwNgUCnq0QkpHyGVZPtGFxwXiDvpvgECgYA5PoB+nY8iDiRaJNko9w0hL4AeKogwf+4TbCw+KWVEn6jhuJa4LFTdSqp89PktQaoVpwv92el/AhYjWOl/jVCm122f9b7GyoelbjMNolToDwe5pF5RnSpEuDdLy9MfE8LnE3PlbE7E5BipQ3UjSebkgNboLHH/lNZA5qvEtvbfvQ==', 'MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAut9evKRuHJ/2QNfDlLwvN/S8l9hRAgPbb0u61bm4AtzaTGsLeMtScetxTWJnVvAVpMS9luhEJjt+Sbk5TNLArsgzzwARgaTKOLMT1TvWAK5EbHyI+eSrc3s7Awe1VYGwcubRFWDm16eQLv0k7iqiw+4mweHSz/wWyvBJVgwLoQ02btVtAQErCfSJCOmt0Q/oJQjj08YNRV4EKzB19+f5A+HQVAKy72dSybTzAK+3FPtTtNen/+b5wGeat7c32dhYHnGorPkPeXLtsqqUTp1su5fMfd4lElNdZaoCI7osZxWWUo17vBCZnyeXc9fk0qwD9mK6yRAxNbrY72Xx5VqIqwIDAQAB', 'http://api.auauz.net/api/aliPay/return', 'RSA2', '2088102176044281');
COMMIT;

-- ----------------------------
-- Table structure for tool_email_config
-- ----------------------------
DROP TABLE IF EXISTS `tool_email_config`;
CREATE TABLE `tool_email_config` (
                                     `config_id` bigint(20) NOT NULL COMMENT 'ID',
                                     `from_user` varchar(255) DEFAULT NULL COMMENT '收件人',
                                     `host` varchar(255) DEFAULT NULL COMMENT '邮件服务器SMTP地址',
                                     `pass` varchar(255) DEFAULT NULL COMMENT '密码',
                                     `port` varchar(255) DEFAULT NULL COMMENT '端口',
                                     `user` varchar(255) DEFAULT NULL COMMENT '发件者用户名',
                                     PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='邮箱配置';

-- ----------------------------
-- Records of tool_email_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_local_storage
-- ----------------------------
DROP TABLE IF EXISTS `tool_local_storage`;
CREATE TABLE `tool_local_storage` (
                                      `storage_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                      `real_name` varchar(255) DEFAULT NULL COMMENT '文件真实的名称',
                                      `name` varchar(255) DEFAULT NULL COMMENT '文件名',
                                      `suffix` varchar(255) DEFAULT NULL COMMENT '后缀',
                                      `path` varchar(255) DEFAULT NULL COMMENT '路径',
                                      `type` varchar(255) DEFAULT NULL COMMENT '类型',
                                      `size` varchar(100) DEFAULT NULL COMMENT '大小',
                                      `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                                      `update_by` varchar(255) DEFAULT NULL COMMENT '更新者',
                                      `create_time` datetime DEFAULT NULL COMMENT '创建日期',
                                      `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                                      PRIMARY KEY (`storage_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='本地存储';

-- ----------------------------
-- Records of tool_local_storage
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_qiniu_config
-- ----------------------------
DROP TABLE IF EXISTS `tool_qiniu_config`;
CREATE TABLE `tool_qiniu_config` (
                                     `config_id` bigint(20) NOT NULL COMMENT 'ID',
                                     `access_key` text DEFAULT NULL COMMENT 'accessKey',
                                     `bucket` varchar(255) DEFAULT NULL COMMENT 'Bucket 识别符',
                                     `host` varchar(255) NOT NULL COMMENT '外链域名',
                                     `secret_key` text DEFAULT NULL COMMENT 'secretKey',
                                     `type` varchar(255) DEFAULT NULL COMMENT '空间类型',
                                     `zone` varchar(255) DEFAULT NULL COMMENT '机房',
                                     PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='七牛云配置';

-- ----------------------------
-- Records of tool_qiniu_config
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for tool_qiniu_content
-- ----------------------------
DROP TABLE IF EXISTS `tool_qiniu_content`;
CREATE TABLE `tool_qiniu_content` (
                                      `content_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                      `bucket` varchar(255) DEFAULT NULL COMMENT 'Bucket 识别符',
                                      `name` varchar(180) DEFAULT NULL COMMENT '文件名称',
                                      `size` varchar(255) DEFAULT NULL COMMENT '文件大小',
                                      `type` varchar(255) DEFAULT NULL COMMENT '文件类型：私有或公开',
                                      `url` varchar(255) DEFAULT NULL COMMENT '文件url',
                                      `suffix` varchar(255) DEFAULT NULL COMMENT '文件后缀',
                                      `update_time` datetime DEFAULT NULL COMMENT '上传或同步的时间',
                                      PRIMARY KEY (`content_id`) USING BTREE,
                                      UNIQUE KEY `uniq_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=COMPACT COMMENT='七牛云文件存储';

-- ----------------------------
-- Records of tool_qiniu_content
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train
-- ----------------------------
DROP TABLE IF EXISTS `train`;
CREATE TABLE `train` (
                         `train_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                         `pilot_id` bigint(20) DEFAULT NULL COMMENT '飞行员ID',
                         `plane_id` bigint(20) DEFAULT NULL COMMENT '机型ID',
                         `item_ids` varchar(255) DEFAULT NULL COMMENT '训练项目',
                         `date` date DEFAULT NULL COMMENT '训练日期',
                         `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                         `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
                         `update_time` datetime DEFAULT NULL ON UPDATE current_timestamp() COMMENT '更新时间',
                         `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                         PRIMARY KEY (`train_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='训练';

-- ----------------------------
-- Records of train
-- ----------------------------
BEGIN;
INSERT INTO `train` (`train_id`, `pilot_id`, `plane_id`, `item_ids`, `date`, `create_by`, `create_time`, `update_time`, `update_by`) VALUES (19, 4, 1, NULL, '2025-06-28', 'admin', '2025-06-28 17:00:53', '2025-06-28 17:00:53', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_dmjyhx
-- ----------------------------
DROP TABLE IF EXISTS `train_dmjyhx`;
CREATE TABLE `train_dmjyhx` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                `train_id` bigint(20) NOT NULL,
                                `train_item_id` bigint(20) NOT NULL,
                                `xlq` varchar(255) DEFAULT NULL COMMENT '训练前(心率，呼吸，血压，心电图)',
                                `xl461` varchar(255) DEFAULT NULL,
                                `xl462` varchar(255) DEFAULT NULL,
                                `xl463` varchar(255) DEFAULT NULL,
                                `xl46_xyh` varchar(255) DEFAULT NULL COMMENT '4-6KPa 泄压后 3min',
                                `xl68` varchar(255) DEFAULT NULL,
                                `xl68_xyh` varchar(255) DEFAULT NULL,
                                `xl810` varchar(255) DEFAULT NULL,
                                `xl810_xyh` varchar(255) DEFAULT NULL,
                                `feels` varchar(255) DEFAULT NULL,
                                `sxbx` varchar(255) DEFAULT NULL COMMENT '书写表现',
                                `result` tinyint(4) DEFAULT NULL,
                                `jy` varchar(255) DEFAULT NULL,
                                `create_by` varchar(255) DEFAULT NULL,
                                `create_time` datetime DEFAULT NULL,
                                `update_time` datetime DEFAULT NULL,
                                `date` datetime DEFAULT NULL COMMENT '记录日期',
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_dmjyhx
-- ----------------------------
BEGIN;
INSERT INTO `train_dmjyhx` (`id`, `train_id`, `train_item_id`, `xlq`, `xl461`, `xl462`, `xl463`, `xl46_xyh`, `xl68`, `xl68_xyh`, `xl810`, `xl810_xyh`, `feels`, `sxbx`, `result`, `jy`, `create_by`, `create_time`, `update_time`, `date`, `update_by`) VALUES (1, 10, 12, '1|454|23', '23|2|2', '4|32|32', '4|432|32', '4|34|32', '2|2342|32', '3|3|32', '32|23|3', '3|23|23', '1|23', '23', 2, '23', '123', '2025-05-14 22:46:35', '2025-05-14 22:47:03', '2025-05-23 00:00:00', NULL);
INSERT INTO `train_dmjyhx` (`id`, `train_id`, `train_item_id`, `xlq`, `xl461`, `xl462`, `xl463`, `xl46_xyh`, `xl68`, `xl68_xyh`, `xl810`, `xl810_xyh`, `feels`, `sxbx`, `result`, `jy`, `create_by`, `create_time`, `update_time`, `date`, `update_by`) VALUES (2, 9, 12, '1|1|1', '2|2|2', '3|3|3', '4|4|1', '1|5|2', '2|6|3', '3|7|1', '4|1|2', '5|2|3', '2|4|3|213', '123', 2, '123', 'dfas', '2025-05-28 21:07:13', '2025-05-28 21:07:13', '2025-05-28 00:00:00', NULL);
INSERT INTO `train_dmjyhx` (`id`, `train_id`, `train_item_id`, `xlq`, `xl461`, `xl462`, `xl463`, `xl46_xyh`, `xl68`, `xl68_xyh`, `xl810`, `xl810_xyh`, `feels`, `sxbx`, `result`, `jy`, `create_by`, `create_time`, `update_time`, `date`, `update_by`) VALUES (3, 13, 11, '11|1|1', '1|1|1', '1|1|1', '1|0|1', '1|1|1', '1|1|1', '1|1|1', '1|1|1', '1|1|1', '3|2|1|4|213', '123', 2, '123', 'admin', '2025-06-28 12:54:02', '2025-06-28 15:00:17', NULL, 'admin');
INSERT INTO `train_dmjyhx` (`id`, `train_id`, `train_item_id`, `xlq`, `xl461`, `xl462`, `xl463`, `xl46_xyh`, `xl68`, `xl68_xyh`, `xl810`, `xl810_xyh`, `feels`, `sxbx`, `result`, `jy`, `create_by`, `create_time`, `update_time`, `date`, `update_by`) VALUES (4, 17, 11, 'null|null|null', 'null|null|null', 'null|null|null', 'null|null|null', 'null|null|null', 'null|null|null', 'null|null|null', 'null|null|null', 'null|null|null', '', NULL, 1, NULL, 'admin', '2025-06-28 16:37:00', '2025-06-28 16:37:00', NULL, 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_dycgksl
-- ----------------------------
DROP TABLE IF EXISTS `train_dycgksl`;
CREATE TABLE `train_dycgksl` (
                                 `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                 `train_id` bigint(20) NOT NULL,
                                 `train_item_id` bigint(20) NOT NULL,
                                 `xlq_dm` varchar(255) DEFAULT NULL COMMENT '训练前地面(血氧|心率|呼吸|血压)',
                                 `xl5500_xypd` varchar(255) DEFAULT NULL COMMENT ' 5500m吸氧排氮(血氧|心率|呼吸|血压)',
                                 `xl5500` varchar(255) DEFAULT NULL COMMENT ' 5500m即可(血氧|心率|呼吸|血压)',
                                 `xlh5500` varchar(255) DEFAULT NULL COMMENT '7000回到5500m即可(血氧|心率|呼吸|血压)',
                                 `xlh550060` varchar(255) DEFAULT NULL COMMENT '5500m 60min(血氧|心率|呼吸|血压)',
                                 `xlh5500120` varchar(255) DEFAULT NULL COMMENT '5500m 120min(血氧|心率|呼吸|血压)',
                                 `xlh5500180` varchar(255) DEFAULT NULL COMMENT '5500m 180min(血氧|心率|呼吸|血压)',
                                 `xlh5500240` varchar(255) DEFAULT NULL COMMENT '5500m 240min(血氧|心率|呼吸|血压)',
                                 `xlh5500300` varchar(255) DEFAULT NULL COMMENT '5500m 300min(血氧|心率|呼吸|血压)',
                                 `xl7000` varchar(255) DEFAULT NULL COMMENT '7000m 即刻(血氧饱和|心率|呼吸|血压)',
                                 `xl700020` varchar(255) DEFAULT NULL COMMENT '7000m 20min(血氧饱和|心率|呼吸|血压)',
                                 `xl700040` varchar(255) DEFAULT NULL COMMENT '7000m 40min(血氧饱和|心率|呼吸|血压)',
                                 `xl700060` varchar(255) DEFAULT NULL COMMENT '7000m 60min(血氧饱和|心率|呼吸|血压)',
                                 `xl700080` varchar(255) DEFAULT NULL COMMENT '7000m 80min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000100` varchar(255) DEFAULT NULL COMMENT '7000m 100min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000120` varchar(255) DEFAULT NULL COMMENT '7000m 120min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000140` varchar(255) DEFAULT NULL COMMENT '7000m 140min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000160` varchar(255) DEFAULT NULL COMMENT '7000m 160min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000180` varchar(255) DEFAULT NULL COMMENT '7000m 180min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000200` varchar(255) DEFAULT NULL COMMENT '7000m 200min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000220` varchar(255) DEFAULT NULL COMMENT '7000m 220min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000240` varchar(255) DEFAULT NULL COMMENT '7000m 240min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000260` varchar(255) DEFAULT NULL COMMENT '7000m 260min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000280` varchar(255) DEFAULT NULL COMMENT '7000m 280min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000300` varchar(255) DEFAULT NULL COMMENT '7000m 300min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000320` varchar(255) DEFAULT NULL COMMENT '7000m 320min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000340` varchar(255) DEFAULT NULL COMMENT '7000m 340min(血氧饱和|心率|呼吸|血压)',
                                 `xl7000360` varchar(255) DEFAULT NULL COMMENT '7000m 360min(血氧饱和|心率|呼吸|血压)',
                                 `xlh_dm` varchar(255) DEFAULT NULL COMMENT '训练后地面(血氧|心率|呼吸|血压)',
                                 `feels` varchar(255) DEFAULT NULL COMMENT '主观症状',
                                 `sxbx` varchar(255) DEFAULT NULL COMMENT '书写表现',
                                 `result` varchar(255) DEFAULT NULL COMMENT '判定结果',
                                 `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                                 `date` datetime DEFAULT NULL,
                                 `create_by` varchar(255) DEFAULT NULL,
                                 `create_time` datetime DEFAULT NULL,
                                 `update_time` datetime DEFAULT NULL,
                                 `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_dycgksl
-- ----------------------------
BEGIN;
INSERT INTO `train_dycgksl` (`id`, `train_id`, `train_item_id`, `xlq_dm`, `xl5500_xypd`, `xl5500`, `xlh5500`, `xlh550060`, `xlh5500120`, `xlh5500180`, `xlh5500240`, `xlh5500300`, `xl7000`, `xl700020`, `xl700040`, `xl700060`, `xl700080`, `xl7000100`, `xl7000120`, `xl7000140`, `xl7000160`, `xl7000180`, `xl7000200`, `xl7000220`, `xl7000240`, `xl7000260`, `xl7000280`, `xl7000300`, `xl7000320`, `xl7000340`, `xl7000360`, `xlh_dm`, `feels`, `sxbx`, `result`, `jy`, `date`, `create_by`, `create_time`, `update_time`, `update_by`) VALUES (1, 9, 11, '1|4|4|3', '3|5|5|3', '2|5|34|3', '6|3|6|', '54|4|6|4', '3|56|666|4', '2|7|6|4', '1|76|54|4', '2|5|43|44', '4|6|55|4', '5|7||4', '6|7|66|5', '1|7|6|6', '2|6|6|6', '3|5|55|7', '4|4|4|7', '5|43|4|6', '6|3|44|5', '1||3|54', '3|45|3|4', '4|66|232|3', '5|7|2|3', '6|7|2|33', '1|7|23|3', '2|87||3', '3|75|44|33', '4|5||3', '5|43|5|33', '3|44|3|5', '2|5', 'ddasaa', '2', 'dddd', '2025-05-28 00:00:00', 'dasf', '2025-05-28 21:34:35', '2025-05-28 21:34:51', NULL);
INSERT INTO `train_dycgksl` (`id`, `train_id`, `train_item_id`, `xlq_dm`, `xl5500_xypd`, `xl5500`, `xlh5500`, `xlh550060`, `xlh5500120`, `xlh5500180`, `xlh5500240`, `xlh5500300`, `xl7000`, `xl700020`, `xl700040`, `xl700060`, `xl700080`, `xl7000100`, `xl7000120`, `xl7000140`, `xl7000160`, `xl7000180`, `xl7000200`, `xl7000220`, `xl7000240`, `xl7000260`, `xl7000280`, `xl7000300`, `xl7000320`, `xl7000340`, `xl7000360`, `xlh_dm`, `feels`, `sxbx`, `result`, `jy`, `date`, `create_by`, `create_time`, `update_time`, `update_by`) VALUES (2, 13, 10, '3|54|343|1111', '5|54|43|', '4|54|43|123123', '54|34||', '54|345||', '53|345||', '453|345||', '54|345||', '564|345||', '5|534|453|', '5|53|453|', '44|43|543|', '3|453||', '3|453|53|', '6|45345|453|', '35|354|45345|', '45|345|34|', '4|354|5345|', '64|345|345|', '654|354|345|', '53|34|354|', '53|34||', '563|34||', '65|34||', '3564|34||', '54|34||', '564|34||', '564|345||', '564|34||', '4|3|2|1|123', '123', '2', '123', NULL, 'admin', '2025-06-28 15:12:49', '2025-06-28 15:12:49', 'admin');
INSERT INTO `train_dycgksl` (`id`, `train_id`, `train_item_id`, `xlq_dm`, `xl5500_xypd`, `xl5500`, `xlh5500`, `xlh550060`, `xlh5500120`, `xlh5500180`, `xlh5500240`, `xlh5500300`, `xl7000`, `xl700020`, `xl700040`, `xl700060`, `xl700080`, `xl7000100`, `xl7000120`, `xl7000140`, `xl7000160`, `xl7000180`, `xl7000200`, `xl7000220`, `xl7000240`, `xl7000260`, `xl7000280`, `xl7000300`, `xl7000320`, `xl7000340`, `xl7000360`, `xlh_dm`, `feels`, `sxbx`, `result`, `jy`, `date`, `create_by`, `create_time`, `update_time`, `update_by`) VALUES (3, 17, 10, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '|', NULL, '2', NULL, NULL, 'admin', '2025-06-28 16:36:58', '2025-06-28 16:36:58', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_dycxsjy
-- ----------------------------
DROP TABLE IF EXISTS `train_dycxsjy`;
CREATE TABLE `train_dycxsjy` (
                                 `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                 `train_id` bigint(20) NOT NULL,
                                 `train_item_id` bigint(20) NOT NULL,
                                 `jyq_dm` varchar(255) DEFAULT NULL COMMENT '减压前地面(血氧|心率|呼吸|血压)',
                                 `jyq2500` varchar(255) DEFAULT NULL COMMENT '减压前2500m(血氧|心率|呼吸|血压)',
                                 `jy5500` varchar(255) DEFAULT NULL COMMENT '减压前5500m(血氧|心率|呼吸|血压)',
                                 `jyh2500` varchar(255) DEFAULT NULL COMMENT '减压后5500m(血氧|心率|呼吸|血压)',
                                 `jyh5500` varchar(255) DEFAULT NULL COMMENT '减压后5500m(血氧|心率|呼吸|血压)',
                                 `jyh1m` varchar(255) DEFAULT NULL COMMENT '减压后 1min',
                                 `jyh_dm` varchar(255) DEFAULT NULL COMMENT '减压后地面',
                                 `result` varchar(255) DEFAULT NULL,
                                 `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                                 `date` datetime DEFAULT NULL,
                                 `create_by` varchar(255) DEFAULT NULL,
                                 `create_time` datetime DEFAULT NULL,
                                 `update_time` datetime DEFAULT NULL,
                                 `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_dycxsjy
-- ----------------------------
BEGIN;
INSERT INTO `train_dycxsjy` (`id`, `train_id`, `train_item_id`, `jyq_dm`, `jyq2500`, `jy5500`, `jyh2500`, `jyh5500`, `jyh1m`, `jyh_dm`, `result`, `jy`, `date`, `create_by`, `create_time`, `update_time`, `update_by`) VALUES (1, 9, 10, '1|1|2|2', '2|2|3|3', '3|3|4|4', '5|5|6|6', NULL, '4|4|5|5', '6|6|7|7', '1', 'da', '2025-06-25 00:00:00', '123', '2025-05-28 21:42:36', '2025-05-28 21:42:36', NULL);
INSERT INTO `train_dycxsjy` (`id`, `train_id`, `train_item_id`, `jyq_dm`, `jyq2500`, `jy5500`, `jyh2500`, `jyh5500`, `jyh1m`, `jyh_dm`, `result`, `jy`, `date`, `create_by`, `create_time`, `update_time`, `update_by`) VALUES (2, 13, 9, '1|7|3|65', '2|8|3|4', '3|7|4|3', '5|5|7|2', NULL, '4|6|56|23', '6|4|7|3', '2', 'daf', NULL, 'admin', '2025-06-25 22:24:13', '2025-06-28 16:16:01', 'admin');
INSERT INTO `train_dycxsjy` (`id`, `train_id`, `train_item_id`, `jyq_dm`, `jyq2500`, `jy5500`, `jyh2500`, `jyh5500`, `jyh1m`, `jyh_dm`, `result`, `jy`, `date`, `create_by`, `create_time`, `update_time`, `update_by`) VALUES (3, 17, 9, '', '', '', '', NULL, '', '', '1', NULL, NULL, 'admin', '2025-06-28 16:36:54', '2025-06-28 16:36:54', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_feel
-- ----------------------------
DROP TABLE IF EXISTS `train_feel`;
CREATE TABLE `train_feel` (
                              `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                              `name` varchar(64) DEFAULT NULL COMMENT '感受名称',
                              `remark` varchar(255) DEFAULT NULL,
                              `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                              PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='训练感受';

-- ----------------------------
-- Records of train_feel
-- ----------------------------
BEGIN;
INSERT INTO `train_feel` (`id`, `name`, `remark`, `update_by`) VALUES (1, '头晕', NULL, NULL);
INSERT INTO `train_feel` (`id`, `name`, `remark`, `update_by`) VALUES (2, '胸闷', NULL, NULL);
INSERT INTO `train_feel` (`id`, `name`, `remark`, `update_by`) VALUES (3, '乏力', NULL, NULL);
INSERT INTO `train_feel` (`id`, `name`, `remark`, `update_by`) VALUES (4, '心慌', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for train_fxybdx
-- ----------------------------
DROP TABLE IF EXISTS `train_fxybdx`;
CREATE TABLE `train_fxybdx` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                                `train_item_id` bigint(20) NOT NULL,
                                `psydz` int(11) DEFAULT NULL COMMENT '平视仪复杂动作判断',
                                `ybdz` int(11) DEFAULT NULL COMMENT '仪表复杂动作判断',
                                `zylx` int(11) DEFAULT NULL COMMENT '自由练习',
                                `gdhxfx` int(11) DEFAULT NULL COMMENT '固定航线飞行',
                                `mnfxzl` int(11) DEFAULT NULL COMMENT '模拟飞行着陆',
                                `sdbsx` int(11) DEFAULT NULL COMMENT '速度表闪现',
                                `gdbsx` int(11) DEFAULT NULL COMMENT '高度表闪现',
                                `psysx` int(11) DEFAULT NULL COMMENT '平视仪闪现',
                                `dpysx` int(11) DEFAULT NULL COMMENT '地平仪闪现',
                                `lpsx` int(11) DEFAULT NULL COMMENT '罗盘闪现',
                                `jxpsy_hxwc` int(11) DEFAULT NULL COMMENT '坚信平视仪_航向误差',
                                `jxpsy_gdwc` int(11) DEFAULT NULL COMMENT '坚信平视仪_高度误差',
                                `jxpsy_fjcj` int(11) DEFAULT NULL COMMENT '坚信平视仪_附加成绩',
                                `jxpsy_bcsj` int(11) DEFAULT NULL COMMENT '坚信平视仪_保持时间',
                                `jxyb_hxwc` int(11) DEFAULT NULL COMMENT '坚信仪表_航向误差',
                                `jxyb_gdwc` int(11) DEFAULT NULL COMMENT '坚信仪表_高度误差',
                                `jxyb_fjcj` int(11) DEFAULT NULL COMMENT '坚信仪表_附加成绩',
                                `jxyb_bcsj` int(11) DEFAULT NULL COMMENT '坚信仪表_保持时间',
                                `result` tinyint(4) DEFAULT NULL COMMENT '评定结果(0:优秀，1：良好，2：合格，3：不合格：4：复训合格)',
                                `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                `create_time` date DEFAULT NULL COMMENT '创建时间',
                                `date` date DEFAULT NULL COMMENT '记录日期',
                                `update_time` date DEFAULT NULL,
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='飞行仪表定向顺序';

-- ----------------------------
-- Records of train_fxybdx
-- ----------------------------
BEGIN;
INSERT INTO `train_fxybdx` (`id`, `train_id`, `train_item_id`, `psydz`, `ybdz`, `zylx`, `gdhxfx`, `mnfxzl`, `sdbsx`, `gdbsx`, `psysx`, `dpysx`, `lpsx`, `jxpsy_hxwc`, `jxpsy_gdwc`, `jxpsy_fjcj`, `jxpsy_bcsj`, `jxyb_hxwc`, `jxyb_gdwc`, `jxyb_fjcj`, `jxyb_bcsj`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (1, 9, 8, 1, 2, 3, 4, 5, 6, 7, 8, 9, 9, 2, 1, 1, 1, 2, 2, 3, 3, 2, '4', '2025-05-28', '2025-05-28', '2025-05-28', NULL);
INSERT INTO `train_fxybdx` (`id`, `train_id`, `train_item_id`, `psydz`, `ybdz`, `zylx`, `gdhxfx`, `mnfxzl`, `sdbsx`, `gdbsx`, `psysx`, `dpysx`, `lpsx`, `jxpsy_hxwc`, `jxpsy_gdwc`, `jxpsy_fjcj`, `jxpsy_bcsj`, `jxyb_hxwc`, `jxyb_gdwc`, `jxyb_fjcj`, `jxyb_bcsj`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (2, 13, 7, 21, 32, 2, 34, 32, 2, 2, 2, 2, 3, 3, 3, 3, 3, 3, 43, 3, 2, 2, 'admin', '2025-06-22', NULL, '2025-06-22', 'admin');
INSERT INTO `train_fxybdx` (`id`, `train_id`, `train_item_id`, `psydz`, `ybdz`, `zylx`, `gdhxfx`, `mnfxzl`, `sdbsx`, `gdbsx`, `psysx`, `dpysx`, `lpsx`, `jxpsy_hxwc`, `jxpsy_gdwc`, `jxpsy_fjcj`, `jxpsy_bcsj`, `jxyb_hxwc`, `jxyb_gdwc`, `jxyb_fjcj`, `jxyb_bcsj`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (3, 17, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'admin', '2025-06-28', NULL, '2025-06-28', 'admin');
INSERT INTO `train_fxybdx` (`id`, `train_id`, `train_item_id`, `psydz`, `ybdz`, `zylx`, `gdhxfx`, `mnfxzl`, `sdbsx`, `gdbsx`, `psysx`, `dpysx`, `lpsx`, `jxpsy_hxwc`, `jxpsy_gdwc`, `jxpsy_fjcj`, `jxpsy_bcsj`, `jxyb_hxwc`, `jxyb_gdwc`, `jxyb_fjcj`, `jxyb_bcsj`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (4, 19, 7, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, 'admin', '2025-06-28', NULL, '2025-06-28', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_gksl
-- ----------------------------
DROP TABLE IF EXISTS `train_gksl`;
CREATE TABLE `train_gksl` (
                              `id` bigint(20) NOT NULL COMMENT 'ID',
                              `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                              `xlq_dm` varchar(255) DEFAULT NULL COMMENT '训练前地面(血氧饱和|心率|呼吸|血压)',
                              `xl_5500_xypd` varchar(255) DEFAULT NULL COMMENT '吸氧排氮(5500m)(血氧饱和|心率|呼吸|血压)',
                              `xl_5500_0` varchar(255) DEFAULT NULL COMMENT '5500 0min(血氧饱和|心率|呼吸|血压)',
                              `xl_5500_60` varchar(255) DEFAULT NULL COMMENT '5500m 20min(血氧饱和|心率|呼吸|血压)',
                              `xl_5500_120` varchar(255) DEFAULT NULL COMMENT '5500m 120min(血氧饱和|心率|呼吸|血压)',
                              `xl_5500_180` varchar(255) DEFAULT NULL COMMENT '5500m 180min(血氧饱和|心率|呼吸|血压)',
                              `xl_5500_240` varchar(255) DEFAULT NULL COMMENT '5500m 240min(血氧饱和|心率|呼吸|血压)',
                              `xl_5500_300` varchar(255) DEFAULT NULL COMMENT '5500m 300min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_0` varchar(255) DEFAULT NULL COMMENT '7000m 0min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_20` varchar(255) DEFAULT NULL COMMENT '7000m 20min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_40` varchar(255) DEFAULT NULL COMMENT '7000m 40min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_60` varchar(255) DEFAULT NULL COMMENT '7000m 60min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_80` varchar(255) DEFAULT NULL COMMENT '7000m 80min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_100` varchar(255) DEFAULT NULL COMMENT '7000m 100min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_120` varchar(255) DEFAULT NULL COMMENT '7000m 120min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_140` varchar(255) DEFAULT NULL COMMENT '7000m 140min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_160` varchar(255) DEFAULT NULL COMMENT '7000m 160min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_180` varchar(255) DEFAULT NULL COMMENT '7000m 180min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_200` varchar(255) DEFAULT NULL COMMENT '7000m 200min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_220` varchar(255) DEFAULT NULL COMMENT '7000m 220min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_240` varchar(255) DEFAULT NULL COMMENT '7000m 240min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_260` varchar(255) DEFAULT NULL COMMENT '7000m 260min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_280` varchar(255) DEFAULT NULL COMMENT '7000m 280min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_300` varchar(255) DEFAULT NULL COMMENT '7000m 300min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_320` varchar(255) DEFAULT NULL COMMENT '7000m 320min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_340` varchar(255) DEFAULT NULL COMMENT '7000m 340min(血氧饱和|心率|呼吸|血压)',
                              `xl_7000_360` varchar(255) DEFAULT NULL COMMENT '7000m 360min(血氧饱和|心率|呼吸|血压)',
                              `xlh_dm` varchar(255) DEFAULT NULL COMMENT '训练后地面(血氧饱和|心率|呼吸|血压)',
                              `zhzz` varchar(255) DEFAULT NULL COMMENT '主观症状(症状id1|症状id2|...|其他)',
                              `sxbx` varchar(255) DEFAULT NULL COMMENT '书写表现',
                              `jg` tinyint(4) DEFAULT NULL COMMENT '结果判定(0:优秀,1:良好,2:合格,3:不合格)',
                              `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                              `date` date DEFAULT NULL COMMENT '记录日期',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                              `create_time` date DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='低压舱高空生理综合验训练';

-- ----------------------------
-- Records of train_gksl
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_item
-- ----------------------------
DROP TABLE IF EXISTS `train_item`;
CREATE TABLE `train_item` (
                              `item_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                              `name` varchar(255) DEFAULT NULL COMMENT '项目名',
                              PRIMARY KEY (`item_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='训练项目';

-- ----------------------------
-- Records of train_item
-- ----------------------------
BEGIN;
INSERT INTO `train_item` (`item_id`, `name`) VALUES (1, '抗荷正压呼吸');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (2, 'HP抗荷动作');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (3, '视性错觉模拟');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (4, '前庭错觉模拟');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (5, '离心机空战');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (6, '前庭功能稳定性');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (7, '飞行仪表定向');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (8, '三维滚轮前庭功能');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (9, '低压舱迅速减压');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (10, '低压舱高空生理');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (11, '地面加压呼吸');
INSERT INTO `train_item` (`item_id`, `name`) VALUES (12, '缺氧体验');
COMMIT;

-- ----------------------------
-- Table structure for train_jyhx
-- ----------------------------
DROP TABLE IF EXISTS `train_jyhx`;
CREATE TABLE `train_jyhx` (
                              `id` bigint(20) NOT NULL COMMENT 'ID',
                              `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                              `xlq` varchar(255) DEFAULT NULL COMMENT '训练前(心率|呼吸|血压|心电图)',
                              `xl_4_6_1` varchar(255) DEFAULT NULL COMMENT '4.0-6.0KPa 1min',
                              `xl_4_6_2` varchar(255) DEFAULT NULL COMMENT '4.0-6.0KPa 2min',
                              `xl_4_6_3` varchar(255) DEFAULT NULL COMMENT '4.0-6.0KPa 3min',
                              `xl_4_6_xyh` varchar(255) DEFAULT NULL COMMENT '4.0-6.0KPa 卸压后3-5min',
                              `xl_6_8` varchar(255) DEFAULT NULL COMMENT '6.0-8.0KPa',
                              `xl_6_8_xyh` varchar(255) DEFAULT NULL COMMENT '6.0-8.0KPa 卸压后3-5min',
                              `xl_8_10` varchar(255) DEFAULT NULL COMMENT '8.0-10.0KPa',
                              `xl_8_10_xyh` varchar(255) DEFAULT NULL COMMENT '8.0-10.0KPa 卸压后3-5min',
                              `zhzz` varchar(255) DEFAULT NULL COMMENT '主观症状(症状id1|症状id2|...|其他)',
                              `jg` tinyint(4) DEFAULT NULL COMMENT '结果判定(0:优秀,1:良好,2:合格,3:不合格)',
                              `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                              `date` date DEFAULT NULL COMMENT '记录日期',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                              `create_time` date DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='低压舱高空生理综合验训练';

-- ----------------------------
-- Records of train_jyhx
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_khdz
-- ----------------------------
DROP TABLE IF EXISTS `train_khdz`;
CREATE TABLE `train_khdz` (
                              `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                              `train_id` bigint(20) NOT NULL COMMENT '训练 ID',
                              `train_item_id` bigint(20) NOT NULL COMMENT '训练项目',
                              `cycz` int(11) DEFAULT NULL COMMENT '心眼垂直距离(cm)',
                              `ajxy` int(11) DEFAULT NULL COMMENT '安静血压(mmhg)',
                              `hpxy_wf` int(1) DEFAULT NULL COMMENT 'HP抗荷动作血压(mmHg)-无抗荷服',
                              `hpxy` int(1) DEFAULT NULL COMMENT 'HP抗荷动作血压(mmHg)-有抗荷服',
                              `xzdl` bit(1) DEFAULT NULL COMMENT '下肢蹬力检测(合格/不合格)',
                              `zxz` int(11) DEFAULT NULL COMMENT '左下肢(kg)',
                              `yxz` int(11) DEFAULT NULL COMMENT '右下肢(kg)',
                              `cxsj` int(11) DEFAULT NULL COMMENT '持续时间(s)',
                              `hpzw` tinyint(4) DEFAULT NULL COMMENT 'PHP 动作掌握程度(0:熟练掌握，1:掌握，2:基本掌握，3:不掌握)',
                              `qxtb` tinyint(4) DEFAULT NULL COMMENT '呼吸曲线与呼吸引导曲线同步程度(0:完全同步，1:同步，2:基本同步，3:不同步)',
                              `g` float DEFAULT NULL COMMENT '提高 G值((训练收缩压-安静收缩呀)/心眼距离/1.28)',
                              `result` tinyint(4) DEFAULT NULL COMMENT '评定结果(0:优秀，1:良好，2:合格，3:不合格)',
                              `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                              `g_wf` float DEFAULT NULL,
                              `create_by` varchar(255) DEFAULT NULL,
                              `date` datetime DEFAULT NULL,
                              `create_time` datetime DEFAULT NULL,
                              `update_time` datetime DEFAULT NULL,
                              `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='HP抗荷动作训练';

-- ----------------------------
-- Records of train_khdz
-- ----------------------------
BEGIN;
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (1, 9, 2, 1, 1, 23, 32, b'0', 23, 123, 123, 1, 0, 22, 2, '123', 11111, '123', '2025-05-28 00:00:00', '2025-05-28 22:16:00', '2025-05-28 22:16:14', NULL);
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (2, 11, 2, 1, 1, 2, 2, b'1', 2, 2, 2, 1, 1, 1, 2, '213', 1, NULL, '2025-06-22 00:00:00', '2025-06-22 10:35:29', '2025-06-22 13:31:03', NULL);
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (3, 12, 2, 1, 2, 2, 2, b'1', 2, 2, 2, 1, 1, 2, 1, '12', 2, NULL, '2025-06-22 00:00:00', '2025-06-22 16:02:38', '2025-06-22 16:03:52', NULL);
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (4, 13, 2, 1, 2, 1, 2, b'0', 3, 4, 5, 0, 0, 11, 2, '222', 22.2, NULL, NULL, '2025-06-22 20:15:15', '2025-06-23 22:07:18', 'admin');
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (5, 14, 2, 1, 2, 2, 22, b'1', 2, 2, 1, 1, 1, 123, 1, '123', 123, 'admin', NULL, '2025-06-28 16:17:22', '2025-06-28 16:17:22', 'admin');
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (6, 17, 2, 1, 1, 1, 12, NULL, 2, 1, 11, NULL, NULL, NULL, 2, NULL, 11, 'admin', NULL, '2025-06-28 16:31:57', '2025-06-28 16:31:57', 'admin');
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (7, 18, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2, NULL, NULL, 'admin', NULL, '2025-06-28 16:41:20', '2025-06-28 16:41:20', 'admin');
INSERT INTO `train_khdz` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `hpxy_wf`, `hpxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `hpzw`, `qxtb`, `g`, `result`, `jy`, `g_wf`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (8, 19, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 'admin', NULL, '2025-06-28 17:19:19', '2025-06-28 21:06:17', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_khzyhx
-- ----------------------------
DROP TABLE IF EXISTS `train_khzyhx`;
CREATE TABLE `train_khzyhx` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                `train_id` bigint(20) NOT NULL COMMENT '训练 ID',
                                `train_item_id` bigint(20) NOT NULL COMMENT '训练项目',
                                `cycz` int(11) DEFAULT NULL COMMENT '心眼垂直距离(cm)',
                                `ajxy` int(11) DEFAULT NULL COMMENT '安静血压(mmhg)',
                                `kfhxy` varchar(255) DEFAULT NULL COMMENT '4KPa抗荷正压呼吸训练血压(mmHg)',
                                `xzdl` bit(1) DEFAULT NULL COMMENT '下肢蹬力检测(0:合格,1:不合格)',
                                `zxz` varchar(255) DEFAULT NULL COMMENT '左下肢2kpa(kg)',
                                `yxz` varchar(255) DEFAULT NULL COMMENT '右下肢(kg)',
                                `cxsj` varchar(255) DEFAULT NULL COMMENT '持续时间(s)',
                                `phpzw` tinyint(4) DEFAULT NULL COMMENT 'PHP 动作掌握程度(0:熟练掌握，1:掌握，2:基本掌握，3:不掌握)',
                                `qxtb` tinyint(4) DEFAULT NULL COMMENT '呼吸曲线与呼吸引导曲线同步程度(0:完全同步，1:同步，2:基本同步，3:不同步)',
                                `result` tinyint(4) DEFAULT NULL COMMENT '评定结果(0:优秀，1:良好，2:合格，3:不合格)',
                                `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                                `create_by` varchar(255) DEFAULT NULL,
                                `date` datetime DEFAULT NULL,
                                `create_time` datetime DEFAULT NULL,
                                `update_time` datetime DEFAULT NULL,
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='抗荷正压呼吸训练';

-- ----------------------------
-- Records of train_khzyhx
-- ----------------------------
BEGIN;
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (1, 9, 1, 123, 123, '3', b'1', '1|4|7', '2|5|8', '3|6|9', 0, 0, 1, '2', '22', '2025-05-20 00:00:00', '2025-05-27 22:41:09', '2025-05-28 22:16:08', NULL);
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (2, 12, 1, 1, 2, '213', b'1', '12|2|2', '2|2|2', '2|2|2', 1, 1, 0, '123', NULL, '2025-06-22 00:00:00', '2025-06-22 15:38:37', '2025-06-22 16:08:23', 'admin');
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (3, 13, 1, 2, 2, '2', b'1', '2|2|23', '3|3|12', '3|33|4', 1, 1, 2, '1234', 'admin', NULL, '2025-06-22 16:11:04', '2025-06-28 16:12:30', 'admin');
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (4, 14, 1, 1, 2, '3', b'1', '33|33|3', '3|3|33', '3|3|3', 0, 1, 0, '123', 'admin', NULL, '2025-06-28 16:16:56', '2025-06-28 16:16:56', 'admin');
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (5, 16, 1, 1, 2, '1', b'1', '11|1|1', '1|1|11', '11|11|', 0, 0, 0, '123', 'admin', NULL, '2025-06-28 16:28:30', '2025-06-28 16:30:39', 'admin');
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (6, 17, 1, 1, 2, '1', b'1', '2|11|1', '1|1|1', '1|1|1', 1, 1, 0, '123', 'admin', NULL, '2025-06-28 16:31:14', '2025-06-28 16:31:14', 'admin');
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (7, 18, 1, NULL, NULL, NULL, NULL, '', '', '', NULL, NULL, 0, NULL, 'admin', NULL, '2025-06-28 16:40:59', '2025-06-28 16:40:59', 'admin');
INSERT INTO `train_khzyhx` (`id`, `train_id`, `train_item_id`, `cycz`, `ajxy`, `kfhxy`, `xzdl`, `zxz`, `yxz`, `cxsj`, `phpzw`, `qxtb`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (8, 19, 1, NULL, NULL, NULL, NULL, '', '', '', NULL, NULL, 0, NULL, 'admin', NULL, '2025-06-28 17:01:24', '2025-06-28 17:04:53', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_lxjkh
-- ----------------------------
DROP TABLE IF EXISTS `train_lxjkh`;
CREATE TABLE `train_lxjkh` (
                               `id` bigint(20) NOT NULL COMMENT 'ID',
                               `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                               `train_item_id` bigint(20) NOT NULL COMMENT '训练项目ID',
                               `train_lxjkh_data_id` bigint(20) NOT NULL COMMENT '离心机抗荷项目ID',
                               `csq_xy` int(11) DEFAULT NULL COMMENT '测试前_血压(mmHg)',
                               `csq_xl` int(11) DEFAULT NULL COMMENT '测试前_心率(bpm)',
                               `csh_xy` int(11) DEFAULT NULL COMMENT '测试后_血压(mmHg)',
                               `csh_xl` int(11) DEFAULT NULL COMMENT '测试后_心率(bpm)',
                               `result` varchar(255) DEFAULT NULL COMMENT '结论',
                               `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                               `create_time` date DEFAULT NULL COMMENT '创建时间',
                               `date` date DEFAULT NULL COMMENT '记录日期',
                               `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                               PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='载人离心机抗荷能力训练';

-- ----------------------------
-- Records of train_lxjkh
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_lxjkh_data
-- ----------------------------
DROP TABLE IF EXISTS `train_lxjkh_data`;
CREATE TABLE `train_lxjkh_data` (
                                    `id` bigint(20) NOT NULL COMMENT 'ID',
                                    `train_lxjkh_id` bigint(20) NOT NULL COMMENT '训练ID',
                                    `tj` varchar(255) NOT NULL COMMENT '条件',
                                    `g` float NOT NULL COMMENT 'G值',
                                    `sj` int(11) DEFAULT NULL COMMENT '持续时间',
                                    `zs` varchar(255) DEFAULT NULL COMMENT '主诉',
                                    `emtz` varchar(255) DEFAULT NULL COMMENT '耳脉体征',
                                    `result` varchar(255) DEFAULT NULL COMMENT '结论',
                                    `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                    `create_time` date DEFAULT NULL COMMENT '创建时间',
                                    `date` date DEFAULT NULL COMMENT '记录日期',
                                    `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='载人离心机抗荷能力训练-数据';

-- ----------------------------
-- Records of train_lxjkh_data
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_lxjkz
-- ----------------------------
DROP TABLE IF EXISTS `train_lxjkz`;
CREATE TABLE `train_lxjkz` (
                               `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                               `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                               `train_item_id` bigint(20) NOT NULL COMMENT '训练项目ID',
                               `csq_xy` int(11) DEFAULT NULL COMMENT '测试前_血压(mmHg)',
                               `csq_xl` int(11) DEFAULT NULL COMMENT '测试前_心率(bpm)',
                               `csh_xy` int(11) DEFAULT NULL COMMENT '测试后_血压(mmHg)',
                               `csh_xl` int(11) DEFAULT NULL COMMENT '测试后_心率(bpm)',
                               `result` varchar(255) DEFAULT NULL COMMENT '结论',
                               `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                               `create_time` date DEFAULT NULL COMMENT '创建时间',
                               `date` date DEFAULT NULL COMMENT '记录日期',
                               `update_time` date DEFAULT NULL,
                               `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                               PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='载人离心机模拟空战动作训练';

-- ----------------------------
-- Records of train_lxjkz
-- ----------------------------
BEGIN;
INSERT INTO `train_lxjkz` (`id`, `train_id`, `train_item_id`, `csq_xy`, `csq_xl`, `csh_xy`, `csh_xl`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `train_lxjkz` (`id`, `train_id`, `train_item_id`, `csq_xy`, `csq_xl`, `csh_xy`, `csh_xl`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (2, 9, 6, 1, 1, 2, 3, '1', '213', '2025-05-28', '2025-05-28', '2025-05-28', NULL);
INSERT INTO `train_lxjkz` (`id`, `train_id`, `train_item_id`, `csq_xy`, `csq_xl`, `csh_xy`, `csh_xl`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (3, 13, 5, 12, 213, 123, 123, '0', 'admin', '2025-06-28', NULL, '2025-06-28', 'admin');
INSERT INTO `train_lxjkz` (`id`, `train_id`, `train_item_id`, `csq_xy`, `csq_xl`, `csh_xy`, `csh_xl`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (4, 17, 5, 123, 123, 123, 123, '1', 'admin', '2025-06-28', NULL, '2025-06-28', 'admin');
INSERT INTO `train_lxjkz` (`id`, `train_id`, `train_item_id`, `csq_xy`, `csq_xl`, `csh_xy`, `csh_xl`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (5, 18, 5, NULL, NULL, NULL, NULL, '1', 'admin', '2025-06-28', NULL, '2025-06-28', 'admin');
INSERT INTO `train_lxjkz` (`id`, `train_id`, `train_item_id`, `csq_xy`, `csq_xl`, `csh_xy`, `csh_xl`, `result`, `create_by`, `create_time`, `date`, `update_time`, `update_by`) VALUES (6, 19, 5, NULL, NULL, NULL, NULL, '0', 'admin', '2025-06-28', NULL, '2025-06-28', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_lxjkz_data
-- ----------------------------
DROP TABLE IF EXISTS `train_lxjkz_data`;
CREATE TABLE `train_lxjkz_data` (
                                    `id` bigint(20) NOT NULL COMMENT 'ID',
                                    `train_lxjkz_id` bigint(20) NOT NULL COMMENT '训练ID',
                                    `tj` varchar(255) NOT NULL COMMENT '条件',
                                    `g` float NOT NULL COMMENT 'G值',
                                    `sj` int(11) DEFAULT NULL COMMENT '持续时间',
                                    `zs` varchar(255) DEFAULT NULL COMMENT '主诉',
                                    `emtz` varchar(255) DEFAULT NULL COMMENT '耳脉体征',
                                    `result` varchar(255) DEFAULT NULL COMMENT '结论',
                                    `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                    `create_time` date DEFAULT NULL COMMENT '创建时间',
                                    `date` date DEFAULT NULL COMMENT '记录日期',
                                    `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='载人离心机模拟空战动作训练-数据';

-- ----------------------------
-- Records of train_lxjkz_data
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_pilot
-- ----------------------------
DROP TABLE IF EXISTS `train_pilot`;
CREATE TABLE `train_pilot` (
                               `pilot_id` bigint(20) NOT NULL AUTO_INCREMENT,
                               `no` varchar(255) DEFAULT NULL COMMENT '疗养号',
                               `name` varchar(255) DEFAULT NULL COMMENT '姓名',
                               `gender` varchar(2) DEFAULT NULL COMMENT '性别',
                               `birthdate` date DEFAULT NULL COMMENT '出生日期',
                               `create_by` varchar(255) DEFAULT NULL COMMENT '创建者',
                               `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                               `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                               `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                               `position` varchar(255) DEFAULT NULL COMMENT '部级别',
                               PRIMARY KEY (`pilot_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_pilot
-- ----------------------------
BEGIN;
INSERT INTO `train_pilot` (`pilot_id`, `no`, `name`, `gender`, `birthdate`, `create_by`, `create_time`, `update_time`, `update_by`, `position`) VALUES (1, '44444', '张三', '女', '2024-07-21', NULL, NULL, '2024-07-30 16:42:02', NULL, NULL);
INSERT INTO `train_pilot` (`pilot_id`, `no`, `name`, `gender`, `birthdate`, `create_by`, `create_time`, `update_time`, `update_by`, `position`) VALUES (2, '123123', '李四', '男', '2024-07-02', NULL, NULL, '2024-07-27 22:09:38', NULL, NULL);
INSERT INTO `train_pilot` (`pilot_id`, `no`, `name`, `gender`, `birthdate`, `create_by`, `create_time`, `update_time`, `update_by`, `position`) VALUES (3, '222', '王五', '男', '2024-07-27', NULL, '2024-07-27 22:12:46', '2024-07-27 22:12:46', NULL, NULL);
INSERT INTO `train_pilot` (`pilot_id`, `no`, `name`, `gender`, `birthdate`, `create_by`, `create_time`, `update_time`, `update_by`, `position`) VALUES (4, '12311', '黄六', '男', '2024-07-18', 'admin', '2024-07-27 22:15:50', '2024-07-27 22:15:50', NULL, '飞行');
COMMIT;

-- ----------------------------
-- Table structure for train_plane
-- ----------------------------
DROP TABLE IF EXISTS `train_plane`;
CREATE TABLE `train_plane` (
                               `plane_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                               `name` varchar(255) DEFAULT NULL COMMENT '机型名称',
                               `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                               PRIMARY KEY (`plane_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_plane
-- ----------------------------
BEGIN;
INSERT INTO `train_plane` (`plane_id`, `name`, `update_by`) VALUES (1, '跑步机', NULL);
COMMIT;

-- ----------------------------
-- Table structure for train_qtcjmn
-- ----------------------------
DROP TABLE IF EXISTS `train_qtcjmn`;
CREATE TABLE `train_qtcjmn` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                `train_id` bigint(20) DEFAULT NULL,
                                `train_item_id` bigint(20) DEFAULT NULL,
                                `qt_ssz` varchar(255) DEFAULT NULL COMMENT '躯体旋转错误_顺时针 90(空间感觉|保持时间)',
                                `qt_nsz` varchar(255) DEFAULT NULL COMMENT '躯体旋转错误_逆时针 90(空间感觉|保持时间)',
                                `qt_tyq` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_仰卧翻转错觉_头右倾(自我空间感觉|保持时间)',
                                `qt_tzq` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_仰卧翻转错觉_头左倾(自我空间感觉|保持时间)',
                                `qt_qdt` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_倾斜翻转错觉_前低头(空间感觉|训练持续时间)',
                                `qt_zl` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_倾斜翻转错觉_直立(空间感觉|训练持续时间)',
                                `zszw` tinyint(4) DEFAULT NULL COMMENT '知识掌握',
                                `result` varchar(255) DEFAULT NULL,
                                `jy` varchar(255) DEFAULT NULL,
                                `create_by` varchar(255) DEFAULT NULL,
                                `date` date DEFAULT NULL,
                                `create_time` date DEFAULT NULL,
                                `update_time` datetime DEFAULT NULL,
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_qtcjmn
-- ----------------------------
BEGIN;
INSERT INTO `train_qtcjmn` (`id`, `train_id`, `train_item_id`, `qt_ssz`, `qt_nsz`, `qt_tyq`, `qt_tzq`, `qt_qdt`, `qt_zl`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (1, 9, 5, '2', '1', '3', '34', '44', '3', 1, '0', '123', '123', '2025-05-28', '2025-05-28', '2025-05-28 22:05:57', NULL);
INSERT INTO `train_qtcjmn` (`id`, `train_id`, `train_item_id`, `qt_ssz`, `qt_nsz`, `qt_tyq`, `qt_tzq`, `qt_qdt`, `qt_zl`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (2, 13, 4, '1|2', '3|2', '3|3', '3|3', '3|3', '3|3', 1, '1', '123', 'admin', NULL, '2025-06-26', '2025-06-26 23:07:27', 'admin');
INSERT INTO `train_qtcjmn` (`id`, `train_id`, `train_item_id`, `qt_ssz`, `qt_nsz`, `qt_tyq`, `qt_tzq`, `qt_qdt`, `qt_zl`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (3, 14, 4, '1|2', '2|12', '2|1', '2|22', '11|2', '22|22', 1, '2', '123', 'admin', NULL, '2025-06-28', '2025-06-28 16:17:44', 'admin');
INSERT INTO `train_qtcjmn` (`id`, `train_id`, `train_item_id`, `qt_ssz`, `qt_nsz`, `qt_tyq`, `qt_tzq`, `qt_qdt`, `qt_zl`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (4, 17, 4, '', '', '', '', '', '', NULL, '2', NULL, 'admin', NULL, '2025-06-28', '2025-06-28 16:33:02', 'admin');
INSERT INTO `train_qtcjmn` (`id`, `train_id`, `train_item_id`, `qt_ssz`, `qt_nsz`, `qt_tyq`, `qt_tzq`, `qt_qdt`, `qt_zl`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (5, 18, 4, '', '', '', '', '', '', NULL, '1', NULL, 'admin', NULL, '2025-06-28', '2025-06-28 16:42:01', 'admin');
INSERT INTO `train_qtcjmn` (`id`, `train_id`, `train_item_id`, `qt_ssz`, `qt_nsz`, `qt_tyq`, `qt_tzq`, `qt_qdt`, `qt_zl`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (6, 19, 4, '', '', '', '', '', '', NULL, '1', NULL, 'admin', NULL, '2025-06-28', '2025-06-28 17:19:26', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_qtcwmn
-- ----------------------------
DROP TABLE IF EXISTS `train_qtcwmn`;
CREATE TABLE `train_qtcwmn` (
                                `id` bigint(20) NOT NULL COMMENT 'ID',
                                `train_id` bigint(20) NOT NULL COMMENT '训练 ID',
                                `train_item_id` bigint(20) NOT NULL COMMENT '训练项目',
                                `qtxz_ssz_gj` varchar(255) DEFAULT NULL COMMENT '躯体旋转错误_顺时针90_自我空间感觉',
                                `qtxz_ssz_sj` varchar(255) DEFAULT NULL COMMENT '躯体旋转错误_顺时针90_训练持续时间',
                                `klal_ywfz_tyq_gj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_仰卧翻转错觉_头右倾_自我空间感觉',
                                `klal_ywfz_tyq_sj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_仰卧翻转错觉_头右倾_训练持续时间',
                                `klal_ywfz_tzq_gj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_仰卧翻转错觉_头左倾_自我空间感觉',
                                `klal_ywfz_tzq_sj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_仰卧翻转错觉_头左倾_训练持续时间',
                                `klal_qxfz_qdt_gj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_倾斜翻转错觉_前低头_自我空间感觉',
                                `klal_qxfz_qdt_sj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_倾斜翻转错觉_前低头_训练持续时间',
                                `klal_qxfz_zl_gj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_倾斜翻转错觉_直立_自我空间感觉',
                                `klal_qxfz_zl_sj` varchar(255) DEFAULT NULL COMMENT '科里奥利错觉_倾斜翻转错觉_直立_训练持续时间',
                                `zszw` tinyint(4) DEFAULT NULL COMMENT '知识掌握(0：熟练掌握，1：掌握，2：了解：3：不了解)',
                                `result` tinyint(4) DEFAULT NULL COMMENT '评定结果(0:优秀，1：良好，2：合格，3：不合格：4：复训合格)',
                                `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                                `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                `date` date DEFAULT NULL COMMENT '记录日期',
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='前庭错误模拟体验训练';

-- ----------------------------
-- Records of train_qtcwmn
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_qtgnwdx
-- ----------------------------
DROP TABLE IF EXISTS `train_qtgnwdx`;
CREATE TABLE `train_qtgnwdx` (
                                 `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                 `train_id` bigint(20) NOT NULL COMMENT '训练 ID',
                                 `train_item_id` bigint(20) NOT NULL COMMENT '训练项目',
                                 `jsd60` varchar(255) DEFAULT NULL COMMENT '角速度60(训练持续时间|植物神经反应)',
                                 `jsd75` varchar(255) DEFAULT NULL COMMENT '角速度75(训练持续时间|植物神经反应)',
                                 `jsd90` varchar(255) DEFAULT NULL COMMENT '角速度90(训练持续时间|植物神经反应)',
                                 `jsd105` varchar(255) DEFAULT NULL COMMENT '角速度105(训练持续时间|植物神经反应)',
                                 `jsd120` varchar(255) DEFAULT NULL COMMENT '角速度120(训练持续时间|植物神经反应)',
                                 `gnpj` tinyint(4) DEFAULT NULL COMMENT '前庭功能评级(0:A.1:B,2:C,3:D,4:E)',
                                 `fypj` tinyint(4) DEFAULT NULL COMMENT '植物神经反应分级(0,1,2,3)',
                                 `result` tinyint(4) DEFAULT NULL COMMENT '评定结果(0:优秀，1：良好，2：合格，3：不合格：4：复训合格)',
                                 `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                                 `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                 `date` date DEFAULT NULL COMMENT '记录日期',
                                 `create_time` datetime DEFAULT NULL,
                                 `update_time` datetime DEFAULT NULL,
                                 `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='前庭功能稳定性训练';

-- ----------------------------
-- Records of train_qtgnwdx
-- ----------------------------
BEGIN;
INSERT INTO `train_qtgnwdx` (`id`, `train_id`, `train_item_id`, `jsd60`, `jsd75`, `jsd90`, `jsd105`, `jsd120`, `gnpj`, `fypj`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (1, 10, 7, '1', '1', '4', '4', '4', 0, 1, 0, '2', '123', '2025-05-13', '2025-05-14 22:23:01', '2025-05-14 22:46:53', NULL);
INSERT INTO `train_qtgnwdx` (`id`, `train_id`, `train_item_id`, `jsd60`, `jsd75`, `jsd90`, `jsd105`, `jsd120`, `gnpj`, `fypj`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (2, 9, 7, '1', '33', '44', '55', '4', 0, 1, 0, 'dsaf', '1231', '2025-05-28', '2025-05-28 21:54:23', '2025-05-28 21:54:23', NULL);
INSERT INTO `train_qtgnwdx` (`id`, `train_id`, `train_item_id`, `jsd60`, `jsd75`, `jsd90`, `jsd105`, `jsd120`, `gnpj`, `fypj`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (4, 13, 6, '1|1', '1|1', '1|1', '11|1', '1|1', 0, 0, 1, '123', 'admin', NULL, '2025-06-28 15:43:10', '2025-06-28 16:03:08', 'admin');
INSERT INTO `train_qtgnwdx` (`id`, `train_id`, `train_item_id`, `jsd60`, `jsd75`, `jsd90`, `jsd105`, `jsd120`, `gnpj`, `fypj`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (5, 17, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'admin', NULL, '2025-06-28 16:33:10', '2025-06-28 16:33:10', 'admin');
INSERT INTO `train_qtgnwdx` (`id`, `train_id`, `train_item_id`, `jsd60`, `jsd75`, `jsd90`, `jsd105`, `jsd120`, `gnpj`, `fypj`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (6, 19, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 'admin', NULL, '2025-06-28 17:19:32', '2025-06-28 17:19:32', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_qyty
-- ----------------------------
DROP TABLE IF EXISTS `train_qyty`;
CREATE TABLE `train_qyty` (
                              `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                              `train_id` bigint(20) DEFAULT NULL COMMENT '训练ID',
                              `train_item_id` bigint(20) DEFAULT NULL COMMENT '训练项目ID',
                              `xlq` varchar(500) DEFAULT NULL COMMENT '训练前(血氧饱和|心率|呼吸|血压)',
                              `xljk` varchar(500) DEFAULT NULL COMMENT '7500m即刻(血氧饱和|心率|呼吸|血压)',
                              `xl20` varchar(500) DEFAULT NULL COMMENT '7500m 20min(血氧饱和|心率|呼吸|血压)',
                              `xl40` varchar(500) DEFAULT NULL COMMENT '7500m 40min(血氧饱和|心率|呼吸|血压)',
                              `xl60` varchar(500) DEFAULT NULL COMMENT '7500m 60min(血氧饱和|心率|呼吸|血压)',
                              `xl80` varchar(500) DEFAULT NULL COMMENT '7500m 80min(血氧饱和|心率|呼吸|血压)',
                              `xl100` varchar(500) DEFAULT NULL COMMENT '7500m 100min(血氧饱和|心率|呼吸|血压)',
                              `xl120` varchar(500) DEFAULT NULL COMMENT '7500m 120min(血氧饱和|心率|呼吸|血压)',
                              `xl140` varchar(500) DEFAULT NULL COMMENT '7500m 140min(血氧饱和|心率|呼吸|血压)',
                              `xl160` varchar(500) DEFAULT NULL COMMENT '7500m 160min(血氧饱和|心率|呼吸|血压)',
                              `xl180` varchar(500) DEFAULT NULL COMMENT '7500m 180min(血氧饱和|心率|呼吸|血压)',
                              `xl200` varchar(500) DEFAULT NULL COMMENT '7500m 200min(血氧饱和|心率|呼吸|血压)',
                              `xl220` varchar(500) DEFAULT NULL COMMENT '7500m 220min(血氧饱和|心率|呼吸|血压)',
                              `xl240` varchar(500) DEFAULT NULL COMMENT '7500m 240min(血氧饱和|心率|呼吸|血压)',
                              `xl260` varchar(500) DEFAULT NULL COMMENT '7500m 260min(血氧饱和|心率|呼吸|血压)',
                              `xl280` varchar(500) DEFAULT NULL COMMENT '7500m 280min(血氧饱和|心率|呼吸|血压)',
                              `xl300` varchar(500) DEFAULT NULL COMMENT '7500m 300min(血氧饱和|心率|呼吸|血压)',
                              `xl320` varchar(500) DEFAULT NULL COMMENT '7500m 320min(血氧饱和|心率|呼吸|血压)',
                              `xl340` varchar(500) DEFAULT NULL COMMENT '7500m 340min(血氧饱和|心率|呼吸|血压)',
                              `xl360` varchar(500) DEFAULT NULL COMMENT '7500m 360min(血氧饱和|心率|呼吸|血压)',
                              `xlh` varchar(500) DEFAULT NULL COMMENT '训练后(血氧饱和|心率|呼吸|血压)',
                              `feels` varchar(500) DEFAULT NULL COMMENT '主观症状(症状id1|症状id2|...)',
                              `sxbx` varchar(500) DEFAULT NULL COMMENT '书写表现',
                              `result` int(11) DEFAULT NULL COMMENT '结果判定',
                              `jy` varchar(2000) DEFAULT NULL COMMENT '建议',
                              `date` timestamp NULL DEFAULT NULL COMMENT '记录日期',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                              `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
                              `update_time` datetime DEFAULT NULL COMMENT '更新时间',
                              `create_time` datetime DEFAULT NULL COMMENT '创建时间',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='缺氧体验';

-- ----------------------------
-- Records of train_qyty
-- ----------------------------
BEGIN;
INSERT INTO `train_qyty` (`id`, `train_id`, `train_item_id`, `xlq`, `xljk`, `xl20`, `xl40`, `xl60`, `xl80`, `xl100`, `xl120`, `xl140`, `xl160`, `xl180`, `xl200`, `xl220`, `xl240`, `xl260`, `xl280`, `xl300`, `xl320`, `xl340`, `xl360`, `xlh`, `feels`, `sxbx`, `result`, `jy`, `date`, `create_by`, `update_by`, `update_time`, `create_time`) VALUES (1, 13, 12, '2|2|2|22', '23|22|22|2', '12|2|2|2', '34|2|2|2', '4|2|2|22', '22|2|2', '3|2|22|2', '3|2|2|2', '22|2|33|2', '2|22|3|22', '2|2|3|2', '2|2|3|2', '2|2|33|22', '233|22||2', '2|2|3|2', '22|2|3|2', '2|2|3|22', '2|2|null|2', '2|22|null|2', '22|2|2|2', '2|2|2|22', '3|4|2|1|213', '123', 1, '123', NULL, 'admin', 'admin', '2025-06-28 15:57:51', '2025-06-28 15:57:51');
INSERT INTO `train_qyty` (`id`, `train_id`, `train_item_id`, `xlq`, `xljk`, `xl20`, `xl40`, `xl60`, `xl80`, `xl100`, `xl120`, `xl140`, `xl160`, `xl180`, `xl200`, `xl220`, `xl240`, `xl260`, `xl280`, `xl300`, `xl320`, `xl340`, `xl360`, `xlh`, `feels`, `sxbx`, `result`, `jy`, `date`, `create_by`, `update_by`, `update_time`, `create_time`) VALUES (2, 17, 12, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, NULL, NULL, '', '|', NULL, 2, NULL, NULL, 'admin', 'admin', '2025-06-28 16:37:04', '2025-06-28 16:37:04');
COMMIT;

-- ----------------------------
-- Table structure for train_sjcwmn
-- ----------------------------
DROP TABLE IF EXISTS `train_sjcwmn`;
CREATE TABLE `train_sjcwmn` (
                                `id` bigint(20) NOT NULL COMMENT 'ID',
                                `train_id` bigint(20) NOT NULL COMMENT '训练 ID',
                                `train_item_id` bigint(20) NOT NULL COMMENT '训练项目',
                                `xdyd_ssz_gj` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_顺时针60_自我空间感觉',
                                `xdyd_ssz_sj` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_顺时针60_训练持续时间',
                                `xdyd_ssz_fy` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_顺时针60_植物神经反应',
                                `xdyd_nsz_gj` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_顺时针60_自我空间感觉',
                                `xdyd_nsz_sj` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_逆时针60_训练持续时间',
                                `xdyd_nsz_fy` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_逆时针60_植物神经反应',
                                `zdyd_gd_gj` varchar(255) DEFAULT NULL COMMENT '自动运动性错觉_固定激光点_自我空间感觉',
                                `zdyd_gd_sj` varchar(255) DEFAULT NULL COMMENT '自动运动性错觉_固定激光点_训练持续时间',
                                `zdyd_gd_fy` varchar(255) DEFAULT NULL COMMENT '自动运动性错觉_固定激光点_植物神经反应',
                                `zszw` tinyint(4) DEFAULT NULL COMMENT '知识掌握(0：熟练掌握，1：掌握，2：了解：3：不了解)',
                                `result` tinyint(4) DEFAULT NULL COMMENT '评定结果(0:优秀，1：良好，2：合格，3：不合格：4：复训合格)',
                                `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                                `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                `date` date DEFAULT NULL COMMENT '记录日期',
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='视觉错误模拟体验训练';

-- ----------------------------
-- Records of train_sjcwmn
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_statistic
-- ----------------------------
DROP TABLE IF EXISTS `train_statistic`;
CREATE TABLE `train_statistic` (
                                   `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                   `train_item_id` bigint(20) NOT NULL,
                                   `train_id` bigint(20) DEFAULT NULL,
                                   `create_time` datetime DEFAULT NULL,
                                   `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                   PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_statistic
-- ----------------------------
BEGIN;
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (1, 1, 5, '2025-05-04 21:12:27', NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (2, 3, 5, '2025-05-04 21:12:27', NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (4, 1, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (5, 12, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (6, 11, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (7, 10, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (8, 9, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (11, 8, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (12, 7, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (17, 6, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (18, 5, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (20, 4, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (23, 2, 9, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (24, 1, 12, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (25, 2, 12, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (26, 1, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (27, 2, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (28, 7, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (29, 3, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (30, 8, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (31, 9, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (32, 4, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (33, 11, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (34, 10, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (35, 5, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (36, 6, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (38, 12, 13, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (39, 1, 14, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (40, 2, 14, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (41, 3, 14, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (42, 4, 14, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (43, 1, 16, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (44, 1, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (45, 2, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (46, 5, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (47, 4, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (48, 6, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (51, 7, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (52, 8, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (53, 9, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (54, 10, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (55, 11, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (56, 12, 17, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (57, 1, 18, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (58, 2, 18, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (59, 3, 18, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (60, 4, 18, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (61, 5, 18, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (62, 2, 19, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (63, 3, 19, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (64, 4, 19, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (65, 5, 19, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (66, 6, 19, NULL, NULL);
INSERT INTO `train_statistic` (`id`, `train_item_id`, `train_id`, `create_time`, `update_by`) VALUES (67, 7, 19, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for train_swgldc
-- ----------------------------
DROP TABLE IF EXISTS `train_swgldc`;
CREATE TABLE `train_swgldc` (
                                `id` bigint(20) NOT NULL COMMENT 'ID',
                                `train_swglqtgn_id` bigint(20) NOT NULL COMMENT '三轮滚轮训练ID',
                                `sfwl` bit(1) DEFAULT NULL COMMENT '是否有前庭功能紊乱症状:眩晕,头晕,恶心,呕吐',
                                `wlcd` tinyint(4) DEFAULT NULL COMMENT '紊乱程度',
                                `wlsj` tinyint(4) DEFAULT NULL COMMENT '紊乱时间(1:<15s,2:15-60s,3:>60s)',
                                `qtzz` varchar(255) DEFAULT NULL COMMENT '其他症状',
                                `wlgd` tinyint(4) DEFAULT NULL COMMENT '出现紊乱的高度(1:<4000m,2:4000-8000m,3:8000-12000m,4:>12000m)',
                                `wldz` varchar(255) DEFAULT NULL COMMENT '出现紊乱的动作()',
                                `wlzh` varchar(255) DEFAULT NULL COMMENT '出现紊乱的承受载荷(0:-3-0G,1:0-2G,2:2-5G,3:>5G)',
                                `wlsd` tinyint(4) DEFAULT NULL COMMENT '出现紊乱的速度(0:<500km/h,1:500-1000km/h,2:>1000km/h)',
                                `wlcs` tinyint(4) DEFAULT NULL COMMENT '平常紊乱次数',
                                `fxts` date DEFAULT NULL COMMENT '每周飞行天数',
                                `fxjc` date DEFAULT NULL COMMENT '飞行日飞行架次',
                                `xljg` date DEFAULT NULL COMMENT '训练间隔(0:每周,1:每月,2:每半年,3:每年,4:一年以上)',
                                `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                                `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                `create_time` date DEFAULT NULL COMMENT '创建时间',
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='三位滚轮训练调查';

-- ----------------------------
-- Records of train_swgldc
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_swglqtgn
-- ----------------------------
DROP TABLE IF EXISTS `train_swglqtgn`;
CREATE TABLE `train_swglqtgn` (
                                  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                  `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                                  `train_item_id` bigint(20) NOT NULL,
                                  `csq` varchar(255) DEFAULT NULL COMMENT '测试前(血压,心率,呼吸,血氧)',
                                  `csh` varchar(255) DEFAULT NULL COMMENT '测试后(血压,心率,呼吸,血氧)',
                                  `zjzh` varchar(255) DEFAULT NULL COMMENT '受训者自觉症状(0.头痛,2.腹痛,3.心慌,4.胸闷,5,眼花,6,乏力,7.出冷汗,8.其他)',
                                  `fyfj` int(11) DEFAULT NULL COMMENT '前庭功能神经反应分级',
                                  `result` tinyint(4) DEFAULT NULL COMMENT '评定结果(0:合格，1:不合格)',
                                  `date` date DEFAULT NULL COMMENT '记录日期',
                                  `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                                  `create_time` date DEFAULT NULL COMMENT '创建时间',
                                  `update_time` datetime DEFAULT NULL,
                                  `feels` varchar(255) DEFAULT NULL COMMENT '感受',
                                  `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='三位滚轮前庭功能稳定性训练';

-- ----------------------------
-- Records of train_swglqtgn
-- ----------------------------
BEGIN;
INSERT INTO `train_swglqtgn` (`id`, `train_id`, `train_item_id`, `csq`, `csh`, `zjzh`, `fyfj`, `result`, `date`, `create_by`, `create_time`, `update_time`, `feels`, `update_by`) VALUES (1, 10, 9, '12|13|14', '12|13|13', NULL, 1, 3, '2025-05-14', '123', '2025-05-14', '2025-05-14 22:53:40', '1|123', NULL);
INSERT INTO `train_swglqtgn` (`id`, `train_id`, `train_item_id`, `csq`, `csh`, `zjzh`, `fyfj`, `result`, `date`, `create_by`, `create_time`, `update_time`, `feels`, `update_by`) VALUES (2, 9, 9, '1|3|5', '2|4|6', NULL, 2, 2, '2025-05-28', '大师傅', '2025-05-28', '2025-05-28 21:51:12', '4|3|2|答复', NULL);
INSERT INTO `train_swglqtgn` (`id`, `train_id`, `train_item_id`, `csq`, `csh`, `zjzh`, `fyfj`, `result`, `date`, `create_by`, `create_time`, `update_time`, `feels`, `update_by`) VALUES (3, 13, 8, '2|3|3', '34|4|4', NULL, 1, 0, NULL, 'admin', '2025-06-25', '2025-06-25 22:17:50', '3|2|123', 'admin');
INSERT INTO `train_swglqtgn` (`id`, `train_id`, `train_item_id`, `csq`, `csh`, `zjzh`, `fyfj`, `result`, `date`, `create_by`, `create_time`, `update_time`, `feels`, `update_by`) VALUES (4, 17, 8, '', '', NULL, NULL, 1, NULL, 'admin', '2025-06-28', '2025-06-28 16:36:51', '|', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_sxcjmn
-- ----------------------------
DROP TABLE IF EXISTS `train_sxcjmn`;
CREATE TABLE `train_sxcjmn` (
                                `id` bigint(20) NOT NULL AUTO_INCREMENT,
                                `train_id` bigint(20) NOT NULL,
                                `train_item_id` bigint(20) NOT NULL,
                                `cjssz60` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_顺时针60 (自我空间感觉|持续时间|植物神经反应)',
                                `cjnsz60` varchar(255) DEFAULT NULL COMMENT '相对运动性错觉_逆时针60 (自我空间感觉|持续时间|植物神经反应)',
                                `cjgdjgd` varchar(255) DEFAULT NULL COMMENT '自动运动性错觉_固定激光点（自我空间感觉｜持续时间｜植物神经反应）',
                                `zszw` varchar(255) DEFAULT NULL COMMENT '知识掌握',
                                `result` varchar(255) DEFAULT NULL,
                                `jy` varchar(255) DEFAULT NULL,
                                `create_by` varchar(255) DEFAULT NULL,
                                `date` date DEFAULT NULL,
                                `create_time` datetime DEFAULT NULL,
                                `update_time` datetime DEFAULT NULL,
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_sxcjmn
-- ----------------------------
BEGIN;
INSERT INTO `train_sxcjmn` (`id`, `train_id`, `train_item_id`, `cjssz60`, `cjnsz60`, `cjgdjgd`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (1, 9, 4, '1', '34', '33', '0', '1', '213', '123', '2025-05-28', '2025-05-28 22:12:17', '2025-05-28 22:12:17', NULL);
INSERT INTO `train_sxcjmn` (`id`, `train_id`, `train_item_id`, `cjssz60`, `cjnsz60`, `cjgdjgd`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (2, 13, 3, '4|4|4', '5|5|5', '3|3|2', '0', '1', '213', '12', '2025-06-23', '2025-06-23 22:54:20', '2025-06-23 23:05:36', 'admin');
INSERT INTO `train_sxcjmn` (`id`, `train_id`, `train_item_id`, `cjssz60`, `cjnsz60`, `cjgdjgd`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (3, 14, 3, '23|1|2', '12|1|1', '2|122|1', '1', '1', '213', 'admin', NULL, '2025-06-28 16:17:33', '2025-06-28 16:17:33', 'admin');
INSERT INTO `train_sxcjmn` (`id`, `train_id`, `train_item_id`, `cjssz60`, `cjnsz60`, `cjgdjgd`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (4, 18, 3, '', '', '', NULL, '0', NULL, 'admin', NULL, '2025-06-28 16:41:32', '2025-06-28 16:41:32', 'admin');
INSERT INTO `train_sxcjmn` (`id`, `train_id`, `train_item_id`, `cjssz60`, `cjnsz60`, `cjgdjgd`, `zszw`, `result`, `jy`, `create_by`, `date`, `create_time`, `update_time`, `update_by`) VALUES (5, 19, 3, '', '', '', NULL, '1', NULL, 'admin', NULL, '2025-06-28 17:19:23', '2025-06-28 21:06:28', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for train_trains_items
-- ----------------------------
DROP TABLE IF EXISTS `train_trains_items`;
CREATE TABLE `train_trains_items` (
                                      `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
                                      `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                                      `item_id` bigint(20) NOT NULL COMMENT '训练项目ID',
                                      `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                      `create_by` varchar(255) DEFAULT NULL,
                                      `update_time` datetime DEFAULT NULL,
                                      `create_time` datetime DEFAULT NULL,
                                      `result` int(11) DEFAULT NULL COMMENT '结果',
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of train_trains_items
-- ----------------------------
BEGIN;
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (105, 18, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (106, 19, 4, NULL, NULL, NULL, NULL, 1);
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (107, 19, 7, NULL, NULL, NULL, NULL, 1);
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (108, 19, 3, NULL, NULL, NULL, NULL, 1);
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (109, 19, 6, NULL, NULL, NULL, NULL, 1);
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (110, 19, 2, NULL, NULL, NULL, NULL, 1);
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (111, 19, 5, NULL, NULL, NULL, NULL, 1);
INSERT INTO `train_trains_items` (`id`, `train_id`, `item_id`, `update_by`, `create_by`, `update_time`, `create_time`, `result`) VALUES (112, 19, 1, NULL, NULL, NULL, NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for train_tslj
-- ----------------------------
DROP TABLE IF EXISTS `train_tslj`;
CREATE TABLE `train_tslj` (
                              `id` bigint(20) NOT NULL COMMENT 'ID',
                              `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                              `tsgd` tinyint(4) DEFAULT NULL COMMENT '弹射高度(0:30cm,1:70:cm,2:110cm,3:150cm)',
                              `mntq` tinyint(4) DEFAULT NULL COMMENT '特情模拟(0:鸟撞,1:地面故障,2:导弹命中,3:电源故障,4:)',
                              `tsdz` varchar(255) DEFAULT NULL COMMENT '弹射动作评定(弹射时机的判断|双腿收回脚蹬紧|臀部后移背靠紧|肌肉紧缩头靠紧|咬牙闭眼臂夹紧|头身两腿要正直)',
                              `jycs` varchar(255) DEFAULT NULL COMMENT '建议措施(加强时机训练|加强弹射动作要领训练|继续保持|其他)',
                              `jg` tinyint(4) DEFAULT NULL COMMENT '结果判定(0:良好,1:合格,2:不合格)',
                              `date` date DEFAULT NULL COMMENT '记录日期',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                              `create_time` date DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='弹射离机训练';

-- ----------------------------
-- Records of train_tslj
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_tyty
-- ----------------------------
DROP TABLE IF EXISTS `train_tyty`;
CREATE TABLE `train_tyty` (
                              `id` bigint(20) NOT NULL COMMENT 'ID',
                              `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                              `xlq` varchar(255) DEFAULT NULL COMMENT '训练前(血氧饱和|心率|呼吸|血压)',
                              `xljk` varchar(255) DEFAULT NULL,
                              `xl20` varchar(255) DEFAULT NULL,
                              `xl40` varchar(255) DEFAULT NULL,
                              `xl60` varchar(255) DEFAULT NULL,
                              `xl80` varchar(255) DEFAULT NULL,
                              `xl100` varchar(255) DEFAULT NULL,
                              `xl120` varchar(255) DEFAULT NULL,
                              `xl140` varchar(255) DEFAULT NULL,
                              `xl160` varchar(255) DEFAULT NULL,
                              `xl180` varchar(255) DEFAULT NULL,
                              `xl200` varchar(255) DEFAULT NULL,
                              `xl220` varchar(255) DEFAULT NULL,
                              `xl240` varchar(255) DEFAULT NULL,
                              `xl260` varchar(255) DEFAULT NULL,
                              `xl280` varchar(255) DEFAULT NULL,
                              `xl300` varchar(255) DEFAULT NULL,
                              `xl320` varchar(255) DEFAULT NULL,
                              `xl340` varchar(255) DEFAULT NULL,
                              `xl360` varchar(255) DEFAULT NULL,
                              `xlh` varchar(255) DEFAULT NULL,
                              `zhzz` varchar(255) DEFAULT NULL COMMENT '主观症状(症状id1|症状id2|...)',
                              `jg` tinyint(4) DEFAULT NULL COMMENT '结果判定(0:优秀,1:良好,2:合格,3:不合格)',
                              `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                              `date` date DEFAULT NULL COMMENT '记录日期',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                              `create_time` date DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='脱氧体验训练';

-- ----------------------------
-- Records of train_tyty
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_xsjy
-- ----------------------------
DROP TABLE IF EXISTS `train_xsjy`;
CREATE TABLE `train_xsjy` (
                              `id` bigint(20) NOT NULL COMMENT 'ID',
                              `train_id` bigint(20) NOT NULL COMMENT '训练ID',
                              `jyq_dm` varchar(255) DEFAULT NULL COMMENT 'dm(血氧饱和|心率|呼吸|血压|心电图)',
                              `jyq` varchar(255) DEFAULT NULL COMMENT '迅速减压前(2500m)(血氧饱和|心率|呼吸|血压|心电图)',
                              `jysj` varchar(255) DEFAULT NULL COMMENT '迅速减压瞬间(5500m)(血氧饱和|心率|呼吸|血压|心电图)',
                              `jyh` varchar(255) DEFAULT NULL COMMENT '迅速减压后(2500m)(血氧饱和|心率|呼吸|血压|心电图)',
                              `jyh_1m` varchar(255) DEFAULT NULL COMMENT '迅速减压后1分钟(血氧饱和|心率|呼吸|血压|心电图)',
                              `jyh_dm` varchar(255) DEFAULT NULL COMMENT '迅速减压后地面(血氧饱和|心率|呼吸|血压|心电图)',
                              `jg` tinyint(4) DEFAULT NULL COMMENT '结果判定(0:优秀,1:良好,2:合格,3:不合格)',
                              `jy` varchar(255) DEFAULT NULL COMMENT '建议',
                              `date` date DEFAULT NULL COMMENT '记录日期',
                              `create_by` varchar(255) DEFAULT NULL COMMENT '记录人',
                              `create_time` date DEFAULT NULL COMMENT '创建时间',
                              `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='低压舱迅速减压体验训练';

-- ----------------------------
-- Records of train_xsjy
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for train_zjdxza
-- ----------------------------
DROP TABLE IF EXISTS `train_zjdxza`;
CREATE TABLE `train_zjdxza` (
                                `id` bigint(20) NOT NULL COMMENT 'ID',
                                `train_id` bigint(20) NOT NULL COMMENT '训练 ID',
                                `train_item_id` bigint(20) NOT NULL COMMENT '训练项目',
                                `sy` int(11) DEFAULT NULL COMMENT '上仰',
                                `klal_dt` int(11) DEFAULT NULL COMMENT '科里奥利_低头',
                                `klal_tt` int(1) DEFAULT NULL COMMENT '科里奥利_抬头',
                                `fpd` int(1) DEFAULT NULL COMMENT '反坡度',
                                `fjgp` bit(1) DEFAULT NULL COMMENT '假天地线仪故障-飞机改平',
                                `hdjc_xdcj` bit(11) DEFAULT NULL COMMENT '黑洞进场_相对错觉',
                                `hdjc_pdsl` int(11) DEFAULT NULL COMMENT '黑洞进场_跑道竖立',
                                `hdjc_xhx` bit(11) DEFAULT NULL COMMENT '黑洞进场_下划线',
                                `hdjc_zl` bit(11) DEFAULT NULL COMMENT '黑洞进场_着陆',
                                `fxz` bit(11) DEFAULT NULL COMMENT '反旋转',
                                `pd` bit(1) DEFAULT NULL COMMENT '跑道',
                                `hmdk_gd` tinyint(4) DEFAULT NULL COMMENT '海面超低空_高度',
                                `hmdk_jl` tinyint(4) DEFAULT NULL COMMENT '海面超低空_距离',
                                `hmdk_bdzk` tinyint(4) DEFAULT NULL COMMENT '海面超低空_编队状况',
                                `zwhaxdk_gd` tinyint(4) DEFAULT NULL COMMENT '转弯及沿海岸线超低空_高度',
                                `zwhaxdk_jl` tinyint(4) DEFAULT NULL COMMENT '转弯及沿海岸线超低空_距离',
                                `zwhaxdk_bdzk` tinyint(4) DEFAULT NULL COMMENT '转弯及沿海岸线超低空_编队状况',
                                `xgbd_jl` tinyint(4) DEFAULT NULL COMMENT '峡谷编队_距离',
                                `xgbd_bdzk` tinyint(4) DEFAULT NULL COMMENT '峡谷编队_编队状况',
                                `bdcy_jl` tinyint(4) DEFAULT NULL COMMENT '编队穿云_距离',
                                `bdcy_bdzk` tinyint(4) DEFAULT NULL COMMENT '编队穿云_编队状况',
                                `zlzk` tinyint(4) DEFAULT NULL COMMENT '仪表故障着陆_着陆状况',
                                `dyj_jym` tinyint(4) DEFAULT NULL COMMENT '大仰角改出_加油门',
                                `dyj_cx` tinyint(4) DEFAULT NULL COMMENT '大仰角改出_改出程序',
                                `dyj_sj` tinyint(4) DEFAULT NULL COMMENT '大仰角改出_改出时间',
                                `xyj_jym` tinyint(4) DEFAULT NULL COMMENT '小仰角改出_加油门',
                                `xyj_cx` tinyint(4) DEFAULT NULL COMMENT '小仰角改出_改出程序',
                                `xyj_sj` tinyint(4) DEFAULT NULL COMMENT '小仰角改出_改出时间',
                                `fc_sym` tinyint(4) DEFAULT NULL COMMENT '俯冲改出_收油门',
                                `fc_jsb` tinyint(4) DEFAULT NULL COMMENT '俯冲改出_放减速板',
                                `fc_cx` tinyint(4) DEFAULT NULL COMMENT '俯冲改出_改出程序',
                                `fc_sj` tinyint(4) DEFAULT NULL COMMENT '俯冲改出_改出时间',
                                `update_by` varchar(50) DEFAULT NULL COMMENT '最后更新人',
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='空间定向障碍训练';

-- ----------------------------
-- Records of train_zjdxza
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
